How to Query CQ’s JCR with SQL or XPath

The Tools->Query menu option in CRX DE Lite (/crx/de/index.jsp) lets you search the AEM repository for specified content. For example, to query for all Sling jobs, perform the following SQL2 query:

SELECT * FROM [slingevent:Job] where ISDESCENDANTNODE(“/var/eventing/jobs”)

The following will report all DAM Assets:

SELECT * FROM [dam:Asset] where ISDESCENDANTNODE(“/content/dam”)

See this, this or this for additional ways to query CQ’s JCR (repository).