We may find all the AEM pages using the SQL query. Run the below SQL query to get the count and list of all the cq:Page from your project.
SELECT * FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page ,"/content/project")
Below is the screenshot of the result and query execution steps. You may replace the path with your own project path e.g. /content/project
Read Full Blog
Please use this thread to ask the related questions.