Generate Report of all pages and Assets from the Dispatcher. | Community
Skip to main content
P
PJ_AEM001
August 6, 2020
Solved

Generate Report of all pages and Assets from the Dispatcher.

  • August 6, 2020
  • 1 reply
  • 1506 views

I have a requirement where I need an export report of all pages and assets that are on each of the four dispatcher servers also include last modification date (cq:LastModified). One report for each one of the dispatcher servers. 

 

Any help or suggestion will be highly appreciated.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vanegi

Hi @pj_aem001,

To generate report of assets, you can leverage OOTB AEM Asset Report feature available at Tools > Assets > Asset Reports https://helpx.adobe.com/in/experience-manager/6-3/assets/using/asset-reports.html.

 

From the Reports list, select the desired option. Asset Added is selected by default. To customize your report, click Customize Columns in the toolbar. In the Customize Columns dialog, select or deselect the available options to add or remove these options from the report. 

 

For page reports, please check ACS AEM commons utility https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html.

 

You can also fire the following SQL2 query to get the list of all active pages in AEM. 

select * from [cq:PageContent] AS s where s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])
 
Thanks!!

1 reply

vanegi
Adobe Employee
vanegiAdobe EmployeeAccepted solution
Adobe Employee
August 7, 2020

Hi @pj_aem001,

To generate report of assets, you can leverage OOTB AEM Asset Report feature available at Tools > Assets > Asset Reports https://helpx.adobe.com/in/experience-manager/6-3/assets/using/asset-reports.html.

 

From the Reports list, select the desired option. Asset Added is selected by default. To customize your report, click Customize Columns in the toolbar. In the Customize Columns dialog, select or deselect the available options to add or remove these options from the report. 

 

For page reports, please check ACS AEM commons utility https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html.

 

You can also fire the following SQL2 query to get the list of all active pages in AEM. 

select * from [cq:PageContent] AS s where s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])
 
Thanks!!
    P
    PJ_AEM001Author
    August 11, 2020
    Thanks @vanegi for your response, I agree with your solution on Asset detail export. But I am looking for a special case where I have to export the Page and Asset URL from the dispatcher along with its cq:LastModified/jcr:LastModified date. Getting the dates is a tricky part here.
    Terms & ConditionsAccessibility statement

    Loading footer...