Create a report listing all pages by original creation date

[MarkECis]

I'm trying to ascertain when pages on my site were first stood up so I can create a report that lists the date each page was created and the URL or puts all those pages in order based on when they were created. I've tried to find the information I need before I posted a question, and I apologize if this is a ridiculously easy item.

I would appreciate any information you can share to help me get a data file that sorts the pages based on the original creation date. Thank you in advance for any information you can share!

[Saravanan_Dharmaraj]

@MarkECis  Please check this "pages report" given by ACS Commons

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

You can extend the columns it shows in the table or Creating a Report Parameter for creation date.

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/extending.html 

[rawvarun]

You can use the ACS Common Report Builder to generate a list of pages with dates.

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

[arunpatidar · Accepted solution]

You can also try with query builder JSON api

http://localhost:4502/libs/cq/search/content/querydebug.html

type=cq:Page
path=/content/we-retail
orderby.sort=asc
orderby=@jcr:created
p.hits=selective
p.properties=jcr:path jcr:created
p.limit=-1

JSON QueryBuilder Link will give the json with path and create property