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.
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.
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