Is there a way to find out who edited a report?

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é

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.  

forgive the hijack, but is there a similar query to find out which user creates or modifies a field in Studio please?