info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



List all SQL Server Reporting Services Subscriptions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2017-01-27









SQL Server Reporting Services(SSRS) is a Microsoft solution that provides customers with the ability to create, publish and manage reports, then delivering them to users in different methods, whether viewing them in web browser, mobile, file share or an email.






Solution:


Use ReportServer
go

Select
s.[SubscriptionID],
cat.[Path],
s.[DeliveryExtension],
s.[EventType],
Owner.[UserName] 'Owner',
s.[LastRunTime],
Modified.[UserName] 'Modified By',
s.[ModifiedDate],
s.[Description],
s.[LastStatus]
From
dbo.Subscriptions [s]
inner join dbo.[Catalog] [cat] on s.[Report_OID] = cat.[ItemID]
inner join dbo.[Users] [Owner] on s.OwnerID = Owner.UserID
inner join dbo.[Users] [Modified] on s.ModifiedByID = Modified.UserID