info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools Services
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



List all SQL Server Reporting Services Subscriptions
by BF (Principal Consultant; Architecture; Engineering)
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