Provide Sites Report similar to Asset Reports

[#1]

Request for Feature Enhancement (RFE) Summary:	Please provide an ootb feature to create reports for Sites within AEM. Currently there are Asset Reports (Tools > Assets > Reports) available in AEM which provides some very helpful ootb reports which can be generated by the user. The same I would really like to have for Sites as editors often have the request to provide information about their websites, especially about the web pages and their status (unpublished, published). Basically the Publish Report that is available for Assets would be perfect.
Use-case:	As an editor I need to provide an overview to my stakeholder about my websites. They want to know how many pages they contain of and if they are published/unpublished. Similar to Publish report that is available under Tools > Assets > Reports
Current/Experienced Behavior:	Unfortunately no ootb AEM feature available which can be used.
Improved/Expected Behavior:	Provide a Publish report for Sites (under Tools > Sites) similar to the one which is available for assets under Tools > Assets > Reports)
Environment Details (AEM version/service pack, any other specifics if applicable):
Customer-name/Organization name:	Carl Zeiss AG
Screenshot (if applicable):
Code package (if applicable):

asset-reports_publish.png ‏56 KB

[#2]

Hi @lutzU  - You can use ACS commons Reports (https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html) to build the same report for published pages or other requirement. It let you build your query where you can add required parameters and Business users can generate this report anytime they want to see the data.

[#3]

Hi @lutzU 

You can also generate this report by switching to filter view from the sites console -

There is an option to download the report by clicking on CSV Report.

I hope this helps.

Thanks

Narendra

[#4]

@narendragandhi Thank you so much, I wasn't aware of the csv capabilities including the meta data. This is what I was looking for actually. Thanks!

@KM_AEM1 Also thank you for your hint!

[#5]

Btw. If you do a export of a whole website it does provide a Published date (from property cq:lastReplicated). But, this is misleading as the last replication action (cq:lastReplicationAction) is not available you do not know what the currect status of the page is - is it published or not published. "Published date" implicates that page is published currently.

So, it's not the important information that editor want to have for there pages - they are interested in the status basically...

[#6]

@lutzU 

Thanks for proposing this idea

This has been reported to the engineering under the internal reference SITES-20529. The product team will triage this request to verify feasibility based on the prioritization model. This post will be updated according to the Jira request status.