Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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