The following examples are used to query the database & report server. I have included some useful scripts and documents as well.
InstallsPower BI Report Server
SQL Server 2022 Reporting Services
SQL Server 2019 Reporting Services
Visual Studio
Reporting Services Projects 2022
SQL Server Management Studio
Azure Data Studio
Azure DevOps Services
Notepad++
Report Listing
This report is used for querying the deployed reports, their subscriptions and their execution logs. |
Report Subscriptions
This report is used for querying the deployed subscriptions and their schedules. |
Report Execution Log
This report is used for querying the report server exection log table. |
Heat Map Calendar
The report uses a nested tablix inside of a matrix to show a calendar view. The heat map is implemented using a function with a report variable for the base color to produce a gradients of the color. Each day on the calendar can be hyperlinked to a detailed Reporting Services report. |
- Activity Monitor
- Data Sources
- Database Dictionary
- Execution Log
- Heat Map Calendar (using execution log)
- Integrations
- Job Search
- Permissions
- Scheduled Jobs
- Report List
- Subscriptions