I had a SSRS subscription that didn't work correctly, while looking at the subscription via "My Subscriptions", I saw that a yellow exclamation triangle to the left of the report name. I was able to fix the issue, however, I noticed that a few other reports had the same icon. Is there a table in ReportServer that holds the information that I can query to get a list of all the subscriptions that have that icon showing?
Thanks in advance.