Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



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