locked
CRM 2011 Reports - when the report was last accessed or run RRS feed

  • Question

  • Hi All,

    Greeting for the day!!!

    In CRM 2011, how to get the information for the last time the report was accessed or run? Shall I get through Advanced Find (or) Shall I get through SSRS?

    Please share me the information that would be really helpful for me.

    Thanks in Advance.

    Regards,

    Sudhakar

     


    Thanks & Regards, CRM Sudhakar

    Wednesday, October 9, 2013 12:58 PM

All replies

  • Sudhakar,

    If you have CRM OnPremise then you can retrieve information when report was run from SSRS database. All you need to know is Report ID (which you can check in CRM Organization DB).

    This is a query which will retrieve you lastruntime

    SELECT Catalog.Name ,[LastRunTime] FROM [Catalog] INNER JOIN [Subscriptions] ON [Catalog].ItemID = [Subscriptions].Report_OID

    This method is not working in CRM Online because there is not method accessible.

    KG


    My Dynamics CRM Blog: http://bovoweb.blogspot.com

    • Proposed as answer by Mamatha Swamy Thursday, October 10, 2013 4:00 AM
    Wednesday, October 9, 2013 2:02 PM