How to get report of content first Activation date ? | Community
Skip to main content
gvaem
Level 3
Nov 10, 2022 7:39 PM UTC
Solved

How to get report of content first Activation date ?

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.
aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
Sep 5, 2023 5:39 AM UTC

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
View reply

2 replies

aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
Sep 5, 2023 5:39 AM UTC

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.

Translate
Aanchal Sikka
    SantoshSai
    SantoshSai
    New Participant
    Nov 10, 2022 10:07 PM UTC

    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

    Translate
    Santosh Sai
      Terms & ConditionsAccessibility statement

      Loading footer...