Reading recorded events via Query in AEM 6.5 | Community
Skip to main content
S
sameryadav
Level 4
May 19, 2020
Solved

Reading recorded events via Query in AEM 6.5

  • May 19, 2020
  • 1 reply
  • 3213 views

Hi Experts,

 

We have requirement to pull the report for downloaded assets on Asset Share common page. Are there any option to pull the data via Query for downloaded asset user wise?

 

Thanks

~S

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 a74048191r

We have custom reporting on our Asset Share implementation.  You should be able to do something like this:

  • capture Asset Share download events and user on publish instances and create custom audit log entries
  • pull and merge these entries from all publish instances over to your author instance under /etc/somepath
  • schedule a query to run like: 
    • SELECT * FROM [cq:AuditEvent] AS s WHERE ISDESCENDANTNODE([/etc/somepath]) and s.[jcr:primaryType]=('cq:AuditEvent') and s.[cq:type] = 'DOWNLOADED';

1 reply

A
a74048191rAccepted solution
Level 2
May 20, 2020

We have custom reporting on our Asset Share implementation.  You should be able to do something like this:

  • capture Asset Share download events and user on publish instances and create custom audit log entries
  • pull and merge these entries from all publish instances over to your author instance under /etc/somepath
  • schedule a query to run like: 
    • SELECT * FROM [cq:AuditEvent] AS s WHERE ISDESCENDANTNODE([/etc/somepath]) and s.[jcr:primaryType]=('cq:AuditEvent') and s.[cq:type] = 'DOWNLOADED';
    Terms & ConditionsAccessibility statement

    Loading footer...