Hi, Can anyone advise if it's possible for me to run a query to list of SSRS reports in subscription list?

Sure. If I understand that you want a query to return all of the reports that have subscriptions, you can use the Subscriptions table in the ReportServer database. To get the report name and details, I belive that you would join the Subscriptions Report_OID to the Catalog ItemID.Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*

Hi Paul, My apology. I am refering to reports run automatically in the subscription list. Hope this clarifies.

I'm afraid it doesn't clarify your question. If you could take a little more time to describe your objective in detail, perhaps using more than one short sentance, I think I might understand and may be able to help. Please explain what you are trying to accomplish.Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*