SSRS Report Server Database

All:

I am looking for the table that houses this data, especially the "Comments" field. But, it's not straight forward to me. Does anyone have a SQL?

Thanks,

Solution

The data is held in the following table:

ReportServer.dbo.Subscriptions

in the ExtensionSetting column.

It's stored as XML so you'll need to parse the bits you want.

UNION ALL where value of second SELECT depends on the first
Getting the slice index in a pie chart
Date picker not visible on SSRS report for some users on both Chrome and IE
Dynamic SSRS LInk
SSRS Expression Divide by Zero Error
Using DevExpress XtraReport Constructor with parameter
Two Lists with separate groupings on the same page
SSRS report expression issue
Could not load assembly Microsoft.ReportViewer.Common, despite installing the prerequisites
Unable to upload rdl SSRS 2016
Fill Color based on Cell Value
SSRS Data-Driven Subscription: Character Limit on To: Field for Emails
=WeekdayName(weekday(Today())) gives me tomorrow
Dynamic formatting in SSRS matrix column cells
SSRS Report Server - Email on failure?
Location to place favicon for report viewer / report manager
ssrs error Maximum request length exceeded
Tablix: Repeat header rows on each page not working
User defined filters and sorting options for report builder
SSRS Query execution failed for dataset
SSRS How to repeat the table header on each page in print preview
curl with NTLM succeeds but HttpClient with NTLM credentials fails 401
SSRS Dynamic column names
How to open an .rdl file in Visual Studio
How do I add a character at the end of a field to get the total to 100 characters?
SSRS Formatting for negative numbers
The operation cannot be started by an account that uses SQL Server Authentication error When running ssis from stored proc in SSRS
SSRS - When navigating to a linked website or report, then navigate back, lose scroll position and parameters
SSRS Web Service URL Provides an Error (500)
Horizontally and vertically Totals in RDLC Matrix