Report Last Run Date

Has anyone created an Advanced Report SQL query to list reports and the last time a report was run/accessed and by whom? If you have would be great if you could share. This is helpful in cleaning up unused reports. Thanks.

Parents

0 Jay Luna over 3 years ago

Sorry to comment on an old post, but we have the exact same situation with our company. Hundreds of reports created, many of them are one off's, but no real way to tell if they are still being utilized. Can you share any insight if you were able to make any movement with your issue Bud?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sandra Arango over 3 years ago in reply to Jay Luna

I joint this post. We also have the very same requirement.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dmytro Chupylka over 3 years ago in reply to Sandra Arango

That's easy.
If to enable Tracker in the Admin section, then each report run will be tracked and could be reported.
Here is an example

1.Enable Tracker Actiors

2. Create Report on Tracker data:

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 Dmytro Chupylka over 3 years ago in reply to Sandra Arango

That's easy.
If to enable Tracker in the Admin section, then each report run will be tracked and could be reported.
Here is an example

1.Enable Tracker Actiors

2. Create Report on Tracker data:

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data