Expand my Community achievements bar.

SOLVED

Reading recorded events via Query in AEM 6.5

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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';

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

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';