Generate Content Reports In AEM 6.4 Using AEM ACS Commons Utility

Adobe consulting services(ACS) provides a set of utilities that extends the capabilities of AEM. These additional features help the site administrator/content managers. These tools are further extensible for specific needs.

A list of ACS AEM Commons tools are given below.
· Generic Lists - Helps to create custom lists
· Reports - Helps to create, execute and view reports
· Audit log search - Search for audit log events
· Content Packagers - create a query, ACL, and authorizable packages
· Automatic package replication - tooling to automatically replicate AEM packages.
· Dispatcher Flush - Manually flush the AEM Dispatcher cache
· Version Replicator - replicate a specific version of the content
· Version compare - compare AEM page version content and structure
· Redirect Maps - Define redirect Apache https redirect maps
· Page Compare - Compare AEM Page content and structure
· Manage Controlled Processes- Execute and monitor a suite of provided tasks
· JCR Compare - Compare JCR Content trees across AEM instances
· Bulk workflow manager - Execute AEM workflow at scale
· System Notification - Notify AEM users of important AEM Events
· Workflow remover - Power tooling for Workflow instance remover
· Users to CSV Exporter - Export AEM users to CSV for reporting
· QR Code - Quickly review published pages on mobile devices

In this post, we are concentrating on the 'Reports' tool which helps to create, execute and view reports based on our needs.

Introduction AEM Content Reports
Open Source AEM ACS commons project provides AEM Content Reports which is available in version 3.14.0 and supported for AEM 6.3+. This is not an out of the box feature in AEM. These reports can be used to see various reports like,
· The user who has done some mistakes and caused to break the site,
· The user who has activated the home page without approval
· How many pages use the article component which may be deprecated in this release
· How many pages still need to activate in IT site
Content managers need these reports to get a detailed view of the activities happening on the site. These reports provide Web view or CSV download options. Also, these reports are sharable through links and can be saved for future use.

How to Install the AEM Content Reports tool?
Install steps:
· Download ACS AEM Commons package: https://github.com/adobe-consulting-services/acs-aem-commons/releases
· Upload/install package in AEM through the package manager
· Validate installation : Go to {host}:{port}/aem/start.html > Tools > ACS AEM COMMONS > Reports


List of available reports


We have options to
· Create a report
· Update a report
· view a report
· Execute the report
· Download the CSV format report


From the above options, we can generate various reports by mentioning their corresponding parameters.

Sample Result from Content Reports: This report is generated from the 'page report' option to list out all pages under '/content'

We can configure any reports using the below options:
· Customizable queries and columns
· supports user params

Extensible Model: These tools are customizable due to the below reasons.
· Built as AEM component
· Java extensible APIs
· Supports custom executors, params, columns, and exporters

Advantage of AEM Content reports
We can have custom queries executed to generate reports, but the advantage of AEM Content report is given below.