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

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  ,

    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:


    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    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}';
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


    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  ,

    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  , 

    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  

    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.