CODEWITHSUNDEEP
reporting-services
MPJ567
MPJ567

Reputation: 553

How to Find Last Deployment Date of SSRS Report

I manage our SSRS Report Server and I'm curious if there is a way to find out the last date a report was deployed to the report server.

Upvotes: 1

Views: 845

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21683

You can use the Catalog and Users (assuming you want to know who did the change) tables to get this info.

SELECT 
    c.[Path], c.Name
    , c.CreationDate
    ,  cu.UserName
    , c.ModifiedDate
    , cm.UserName
    FROM [Catalog] c 
        JOIN Users cu on cu.UserID = c.CreatedByID
        JOIN Users cm on cm.UserID = c.ModifiedByID

Upvotes: 2

Related Questions