none
ReportServer - who created report

    Question

  • How do i query the ReportServer so i can pull down a list of all published report (names) including who created them and the amount of time they have been access in the last 6 months or so

    • Moved by Kalman Toth Tuesday, December 31, 2013 2:06 PM Not t-sql
    Tuesday, December 31, 2013 2:04 PM

Answers

  • SELECT C.Name
        , C.Path
        , U.UserName
        , Executions = COUNT(1)
    FROM ReportServer..Catalog C
        INNER JOIN ReportServer..Users U ON C.CreatedByID = U.UserID
        LEFT JOIN ReportServer..ExecutionLog L ON C.ItemID = L.ReportID AND TimeStart > GETDATE()-180
    GROUP BY C.Name, U.UserName, C.Path

    Thanks,
    Steve Hood - SimpleSQLServer.com

    • Marked as answer by Sam233 Tuesday, December 31, 2013 2:22 PM
    Tuesday, December 31, 2013 2:16 PM