498
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
#1
André Arnaud de Cal...
292,997
Super User 2025 Season 1
#2
Martin Dráb
231,827
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
