Expand my Community achievements bar.

Adobe Summit 2025: AEM Session Recordings Are Live! Missed a session or want to revisit your favorites? Watch the latest recordings now.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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