We have to be sure subscription owners are not going to leave and make the subscriptions they own fail. Here is a way to make this information visible easily. For the reporting group I made a stored procedure which takes as arguments the current owner, desired owner, and other info to do the work.
c.Name as report_name,
so.UserID as subscription_owner_id,
‘update s set ownerid=”<<new owner id>>” from Subscriptions s where SubscriptionID=”’+cast(s.SubscriptionID as varchar(100))+”” as [command to update subscription]
JOIN ReportServer.dbo.Subscriptions s ON c.ItemID = s.Report_OID
JOIN ReportServer.dbo.ReportSchedule rs ON c.ItemID = rs.ReportID
AND rs.SubscriptionID = s.SubscriptionID
JOIN ReportServer.dbo.Users so on s.OwnerID = so.UserID