Hi @sreenu539
In term of GUI option I would recommend to use Report Builder functionality from ACS Commons:
It is very flexible and simple to use tool. It allows to define report base on query, and generate results a a table that can be seen in AEM or download as csv file and reviewed offline on local computer.
Below is a sample configuration of report that will return list of links to CF build using Simple Fragment model.
- configuration
- result
I used following SQL2 query in my report:
SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam]) and s.[/jcr:content/model/jcr:title] = "Simple Fragment" and s.[/jcr:content/contentFragment] = true
You can also use Query option from crx/de to run query and get the result, but I would consider this more a like an for administrator or developer.