SQL Server Reporting Services is something I don’t play with much, but I had an interesting problem come up this week.

Several months ago we migrated a copy of SSRS from 2016 to 2019 for users to test against and be comfortable that everything works the same on the 2019 version. They did that, eventually, but also apparently some people updated reports on one version and some people updated it in the other. I needed a way of finding out which reports had been updated on which server, so we could redeploy them all to theri final home.

Luckily that’s very possible:

SELECT
c.[Path], c.Name
, c.CreationDate
, cu.UserName as [Created by]
, c.ModifiedDate
, cm.UserName as [Modified By]
FROM [Catalog] c
JOIN Users cu on cu.UserID = c.CreatedByID
JOIN Users cm on cm.UserID = c.ModifiedByID
order by ModifiedDate DESC