How to get report of content first Activation date ?

[gvaem]

Is there a way can we get the list of content on the first activation date of the page within the specific time frame?

[SantoshSai]

Hi @gvaem ,

Not aware of your exact use case, only information that is related here [0]. Though, you can consider below options to achieve the same

1. ACS Report Builder [1]

• ACS report will be very helpful for this use case. You will get the "replication status" of the page. Please follow the below steps.

  1. Install latest ACS commons on AEM author instance.

  2. Open path var/acs-commons/reports/sample-page-report.html?wcmmode=disabled with prefix of your domain name. e.g. http://localhost:4502/var/acs-commons/reports/sample-page-report.html?wcmmode=disabled

  3. Fill the path e.g. /content/we-retail

  4. Execute report and download. Below is the screenshot for better understanding.

  
  
  

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

  eg.

  SELECT * FROM [cq:PageContent] AS s WHERE s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])

  SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/we-retail]) and s.[cq:lastReplicated] >= '2022-11-20T14:37:27.530+05:30'

  path=/content/project
  type=cq:Page
  group.p.or=true
  group.1_property=jcr:content/cq:lastReplicationAction
  group.1_property.value=Deactivate
  group.2_property=jcr:content/cq:lastReplicationAction
  group.2_property.operation=not

[0]: https://experienceleague.adobe.com/docs/experience-manager-64/administering/operations/reporting.htm...

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

Hope that helps!

Regards,

Santosh

[aanchal-sikka · Accepted solution]

Hello @gvaem 

OOTB AEM captures replication info in Audit nodes. The report can be extracted via ACS Report Builder as suggested by @SantoshSai 

Issue:

- Audit nodes are purged regularly, based on the maintenance settings on your environment.

So, the dates that you might be searching for might/might not be available.

- The data that you get from an available window doesn't convey if it is the first activation.

For regular reports:

If you need these reports regularly, I would suggest to append this info as a metadata to the pages. This can be achieved by triggering a workflow on activation of pages.

You can then generate reports based on metadata for any date range.