Reading recorded events via Query in AEM 6.5

[#1]

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

[#2 · Accepted solution]

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