1,608
I have a site with almost 20 years of history, currently on Sl2015, soon moving to 2018. They would like to clean up their reports as many modified and custom reports have been created over the years and only a fraction are in use. That said is there any audit or tracking feature that would tell us which reports are being run and how often, or perhaps a creative way in which we can obtain this. Perhaps adding a trigger to rptruntime?
Please advise. Look forward to a response.
JG
JG,
Yes, if you place a SQL trigger to monitor the system table "rptruntime" it contains the information you looking.
The "rptruntime" is automatically cleared so using a SQL trigger would be my recommend method.
Research could be done on SQL backups to determine reports used over a period of time.
docs.microsoft.com/.../create-trigger-transact-sql
Thanks,
Brad Woodruff
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (