Hi @sumans4511174
You and get by executing JCR SQL2 query.
Firstly get JCR Session from either ResourceResolver or JcrUtils(depends on your implementation).
Get QueryManager then create and execute Query. Check below code example.
QueryManager qm = session.getWorkspace().getQueryManager();
String queryString = "SELECT * FROM [cq:PageContent] AS comp WHERE ISDESCENDANTNODE(comp, \"/conf\") AND [cq:templateType] = \"/libs/settings/dam/cfm/model-types/fragment\"";
Query query = qm.createQuery(queryString, Query.JCR_SQL2);
QueryResult queryResult = query.execute();
RowIterator rowItr = queryResult.getRows();
while(rowItr.hasNext()){
...
}
Hope this is what you are looking for. Cheers!
AG