Some of our other Modules have Audit logs but I do not see that in Reports. We have the date modified but that only shows the last time an edit was made.
Some of our other Modules have Audit logs but I do not see that in Reports. We have the date modified but that only shows the last time an edit was made.
Hi Nicole McGath ,
Thanks for sharing this question.
Sugar stores the ID of the user who made the last modification to the report, but this information is not displayed in the user interface.
If you want to check it, a good option is to create a custom query in Advanced Reports using the following query:
SELECT sr.id, sr.name, sr.date_modified, sr.modified_user_id, u.user_name AS modified_by_username FROM saved_reports sr LEFT JOIN users u ON sr.modified_user_id = u.id WHERE sr.id = '{ReportID}';
This will show you the user who last edited the report.
Let me know if this helps!
Cheers,
André
Thank you for your response!
What we would like to do is see a trail of anyone that has made an edit to the report throughout its life time or even in the last x amount of days.
Hello Nicole McGath ,
Unfortunately, this feature is not currently available. However, I noticed that there is an existing idea request for it:
To help us track interest, we highly encourage you to submit a support case.
This allows us to formally associate your account with the request and demonstrate demand for the feature.
Thank you for your input, and let us know if you have any other questions!
Best,
André
Hello Nicole McGath ,
Unfortunately, this feature is not currently available. However, I noticed that there is an existing idea request for it:
To help us track interest, we highly encourage you to submit a support case.
This allows us to formally associate your account with the request and demonstrate demand for the feature.
Thank you for your input, and let us know if you have any other questions!
Best,
André