Post reply

Reports Modified Data

  • October 18, 2011 at 3:25 am

    #390640

    Hi All,

    we have 200 reports and daily one of the reports will be modified as per business requirements so i need to audit which report has been modified

    on what date and details like

    Report Name

    Last modified date

    user name

    please do the needful ASAP

  • October 20, 2011 at 1:22 am

    #1397077

    All that info is in the reportserver database:

    USE reportserver

    SELECT Name, ModifiedDate, UserName

    FROM dbo.Catalog C

    JOIN dbo.Users U

    ON C.ModifiedById = U.UserID

    ORDER BY ModifiedDate

    [font="Verdana"]Markus Bohse[/font]

  • April 9, 2014 at 11:47 am

    #1704634

    We have SharePoint with Reporting Services in integrated mode and our ReportServer database does not have a Users table. I checked the SharePoint database and could not find a Users table either. Does anyone know where this ModifiedByID could come from then?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply