I have a data driven subscription that generates files and stored into file share - is there a log in SSRS db of the filename and path of the file that is generated? I looked all the table in SSRS I only found the parameters. I'm thinking of making my own log by creating a table on separate db (not in SSRS db) to log the files that are generated -because my app provides users the ability to download the files for certain period of time and then after that files will beleted in the file share and in the log. Also, is there a functionality in SSRS to zip the generated file? Any suggestion how to track and zip the generated files.

There is not zip feature in SSRS. You can use SSIS to call winzip or use a 3rd party SSIS tool like Task Factory to zip it in SSIS. About the log, the view in the SSRS database is called executionlog2. This contains all of the infromation about the report runs. I do not believe the file name is in the log though. You will need to write the name to a table like you suggested. You can have an SSIS package read the execution log and look for the report execution, the have it kick off the other work you need done. Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

Hi JohnWeb, We can get the file name (i.e. the report name) generated by a subscription but we cannot get the path of the file stored on the Windows File Share. To get the name of the file generated by a subscription, we can run the following query on the ReportServer database: SELECT dbo.Subscriptions.SubscriptionID, dbo.Catalog.ItemID, dbo.Catalog.Path, dbo.Catalog.Name FROM dbo.Catalog INNER JOIN dbo.Subscriptions ON Catalog.ItemID=Subscriptions.Report_OID For the method to zip a file generated by a subscription, you can refer to MikeDavis's suggestion to use SSIS. Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support

Hi John, I am also facing the same Issue as you. I wanted to get the FileName that is actually getting stored in the Network Location when the particular Report is Subscribed and scheduled on a Daily basis. my Report Name looks like this ReportName@timestamp. This Report will have a New TimeStamp whenever it gets generated. Please let me know how to get the FileName from the Windows Network shared location. ~ Balram.