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é

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:

Idea Request #95420

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é

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é

hi Andre Serrazina 

As an independent consultant, I don't have access to creating a case or idea in the portal.

However, I do find it amazing that we have to make such a request, as all other enterprise level CRM systems I know have this feature (Salesforce, Dynamic etc.)

impossible to manage which admin users create or make Studio changes.