web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Report Activity in Dyn...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Report Activity in Dynamics SL

(0) Share

Report

Report

Posted on by SL_GP_BC_123

1,090

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Brad_Woodruff 35 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 517 Super User 2026 Season 1

#2

Giorgio Bonacorsi 440

#3

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans