how to change owner in all ssrs reports

Question

how to change owner in all ssrs reports. I believe there is a table on the server named DBUSERS but not sure how to find it.

Answer 1

Hi @James Adkins

You can try to use the code below. Be sure to try it in your development environment first before doing in production and make a backup in production before executing the code.

For guidance, read on this post also.

https://www.mssqltips.com/sqlservertip/6001/ssrs-reportserver-database-overview-and-queries/

USE ReportServer; -- Replace ReportServer with your SSRS database name

UPDATE dbo.Catalog

SET OwnerID = (SELECT UserID FROM dbo.Users WHERE UserName = '<newOwner>')

WHERE OwnerID = (SELECT UserID FROM dbo.Users WHERE UserName = '<currentOwner>')

AND Type = 2; -- Type = 2 specifies that the item is a report