Cool Tips‎ > ‎

Reports and SQL Server Reporting Services (SSRS)

 

Title

Description

Applicability

 

Get list of Report Server Folders   

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


2000, 2005, 2008, 2008R2, 2012



Get Report XML

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


2000, 2005, 2008, 2008R2, 2012 

 

Get Report Object Creation and Change Dates.

Retrieves the creation and change dates and users for all Report Server objects.


2000, 2005, 2008, 2008R2, 2012  

 

Get Report Parameters

Retrieves the report parameters and their attributes for one or many reports.


2000, 2005, 2008, 2008R2, 2012 

 

Get List of Report Data Sources

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


2000, 2005, 2008, 2008R2, 2012 

 


Get List of Report Data Sets

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


2000, 2005, 2008, 2008R2, 2012 

 

Get List of Report Schedules   

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


2000, 2005, 2008, 2008R2, 2012 

 

Get List of Report Subscriptions

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


2000, 2005, 2008, 2008R2, 2012  

 

Get Report Notification Summary        

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


2000, 2005, 2008, 2008R2, 2012  

 

Get List of  Report Cache Policies 

Retrieves a list of cache policies defined against all reports on the Report Server.


2000, 2005, 2008, 2008R2, 2012  

 

Get Report Roles by Report

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


2000, 2005, 2008, 2008R2, 2012   

 

Get Model Roles by Model 

Retrieves a list of all users and roles assigned to one or many models on the Report Server.


2000, 2005, 2008, 2008R2, 2012   

 

Get Report Snapshot History

Retrieves a list of snapshots taken of one or many reports on the Report Server. 


2000, 2005, 2008, 2008R2, 2012    

 

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).



2000, 2005, 2008, 2008R2, 2012     

 

Get Report Execution Detail

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


2000, 2005, 2008, 2008R2, 2012      


 

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. 


2000, 2005, 2008, 2008R2, 2012       

 

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.  


2000, 2005, 2008, 2008R2, 2012       

 

 


Comments