SQL to find list of subscriptions for CSV reports.

How to get filename? I'm looking for SSRS report names for CSV file only.

Hi Bharat,
Please use below. Its the modified version from microsoft.-

USE [ReportServer];
GO 
 
SELECT 
	   CAT.Name ReportName
      ,USR.UserName AS SubscriptionOwner 
      ,SUB.ModifiedDate 
      ,SUB.[Description] 
      ,SUB.EventType 
      ,SUB.DeliveryExtension 
      ,SUB.LastStatus 
      ,SUB.LastRunTime 
      ,SCH.NextRunTime 
      ,SCH.Name AS ScheduleName       
      ,CAT.[Path] AS ReportPath 
      ,CAT.[Description] AS ReportDescription 
FROM dbo.Subscriptions AS SUB 
     INNER JOIN dbo.Users AS USR 
         ON SUB.OwnerID = USR.UserID 
     INNER JOIN dbo.[Catalog] AS CAT 
         ON SUB.Report_OID = CAT.ItemID 
     INNER JOIN dbo.ReportSchedule AS RS 
         ON SUB.Report_OID = RS.ReportID 
            AND SUB.SubscriptionID = RS.SubscriptionID 
     INNER JOIN dbo.Schedule AS SCH 
         ON RS.ScheduleID = SCH.ScheduleID 
WHERE SUB.DeliveryExtension LIKE '%CSV%' OR SUB.ExtensionSettings LIKE '%CSV%'
ORDER BY USR.UserName 
        ,CAT.[Path];

Select allOpen in new window

https://gallery.technet.microsoft.com/scriptcenter/List-all-SSRS-subscriptions-968ae4d5
Hope it helps!

Hi,
Have you tried my last option?

thanks