Counting Report Unit Usage and timestamp it

We are using a report we built using this SQL

 

SELECT DISTINCT

"jiuser".fullname

, date_trunc('minute',"jiaccessevent".event_date) as "accessed on"

, "jiresource".label AS "report label"

, "jiresourcefolder".label AS "folder label"

FROM

((public.jiresource "jiresource"

INNER JOIN

public.jiresourcefolder "jiresourcefolder"

ON ("jiresource".parent_folder = "jiresourcefolder".id))

INNER JOIN

public.jiaccessevent "jiaccessevent"

ON ("jiaccessevent".resource_id = "jiresource".id))

INNER JOIN

public.jiuser "jiuser"

ON ("jiaccessevent".user_id = "jiuser".id)

WHERE ("jiresourcefolder".name NOT IN ('Beta', 'Beta_Reports', 'datasources', 'DataSources', 'datatypes', 'domains', 'Domains', 'Domain_Topics', 'images', 'Images', 'Input_controls', 'Input_Controls'))

Thanks for your note. Although this does not count the number of usages, it will show me when the report has last been opened - which will tell me if the report has been used!