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é
forgive the hijack, but is there a similar query to find out which user creates or modifies a field in Studio please?
forgive the hijack, but is there a similar query to find out which user creates or modifies a field in Studio please?
Hello Tony Romano ,
No problem at all!
We do have an existing idea request for an Audit Log for changes in Studio:
#64452 ( portal.sugarondemand.com/ )
This request has been around for some time. However, if you’re working with a customer who has expressed a need for this feature, we recommend creating a case so our team can properly track the request.
Cheers,
André