Reports and SQL Server Reporting Services (SSRS)


Get list of Report Server Folders - Retrieves a full list of folders on the Report Server from the Report Server Catalog table.

Get Report XML - Retrieves one or many reports as XML from the Report Server Catalog table.

Get Report Object Creation and Change Dates. - Retrieves the creation and change dates and users for all Report Server objects.

Get Report Parameters - Retrieves the report parameters and their attributes for one or many reports.

Get List of Report Data Sources - Retrieves a list of Report Data Sources for one or many reports.

Get List of Report Data Sets - Retrieves a list of Report Data Sets, including columns and data types, for one or many reports.

Get List of Report Schedules - Retrieves a list of all defined schedules stored in the Report Server Schedules table.

Get List of Report Subscriptions - Retrieves a list of all subscriptions defined against one or many reports on the Report Server.

Get Report Notification Summary - Retrieves a summarized list of notifications sent by report for one or many reports on the Report Server.

Get List of Report Cache Policies - Retrieves a list of cache policies defined against all reports on the Report Server.

Get Report Roles by Report - Retrieves a list of all users and roles assigned to one or many reports on the Report Server.

Get Model Roles by Model - Retrieves a list of all users and roles assigned to one or many models on the Report Server.

Get Report Snapshot History - Retrieves a list of snapshots taken of one or many reports on the Report Server.

Get Report Execution Summary - Retrieves a summary of executions for one or many reports on the Report Server, categorized into time bands (eg last week, last month).

Get Report Execution Detail - Retrieves a detailed list of all executions for one or many reports on the Report Server.

Get Report Data Source Details (SPs) - Retrieves a list of stored procedures used by one or many reports on the Report Server and their (report) data source names.

Get Report Data Source Details (TSQL) - Retrieves a list of TSQL code used by one or many reports on the Report Server and their (report) data source names.