How to get report of content first Activation date ? | Community
Skip to main content
G
gvaem
Level 3
November 10, 2022
Solved

How to get report of content first Activation date ?

  • November 10, 2022
  • 2 replies
  • 1072 views

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

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 aanchal-sikka

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.

2 replies

SantoshSai
Community Advisor
SantoshSaiCommunity Advisor
Community Advisor
November 10, 2022

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.html?lang=en#page-activity-report

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

Hope that helps!

Regards,

Santosh

Santosh Sai
    aanchal-sikka
    Community Advisor
    aanchal-sikkaCommunity AdvisorAccepted solution
    Community Advisor
    September 5, 2023

    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.

    Aanchal Sikka
      Terms & ConditionsAccessibility statement

      Loading footer...