Query to find report results not viewed in last X months

Rand Cufley shared this question 18 months ago
Answered

Hi,

(Apologies if I missed the answer to this question in another thread)


We have some users who have made a large number of reports and scheduled them for refreshing every night but no longer are using them. We think this may be impacting database performance. The report detail still show as "Last Run" yesterday in the schedule, however we suspect the users have not been accessing many of the reports.

Are there fields we can access in the Audit View that would show us the last time a user reviewed the report results, or query we can use against the YF database?

Thanks,

Comments (2)

photo
1

Hi Rand,

Unfortunately the schedules will count as report runs so they are going to throw off your search (As you have noticed).

I would suggest searching the event table for eventcode RPTRUN, where the IP source!=0 (or 5). ContentId will be the reportIds, so you can then just select * from reportheader where reportid is not in the previous query results.

Let me know if this makes sense.

Regards,

Nathan

photo
1

Hi Rand,

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan