SQL Sentry Reporting Overview

SQL Sentry offers an expansive list of reporting options, and reports are generated using SQL Server Reporting Services (SSRS) technology. The SQL Sentry client includes the Reporting Services Report Viewer that allows the SQL Sentry reports to be viewed from within the SQL Sentry client. All reports are accessed from the Reports menu.

SQL Sentry Report Viewer

SQL Sentry Reports can be deployed to the Reporting Services 2005 and above server for distribution. Report Deployment Settings is accessed from the Reports menu. For more information about these settings and deploying SQL Sentry Reports, see the Reports topic.

Report Parameters

Once a report is selected, depending on the type of report, the user specifies parameters, including a date and time range for the report. Options are available to save these parameters for later use. To save a set of parameters, select Save on the Report Parameters dialog screen. To load a saved set of parameters, choose a parameter set from the Load Saved Parameters drop-down list. For certain reports, such as the SQL Server Performance report, an option is available to select multiple sets of parameter values. Select Add to Parameter List to add a parameter set to the selected report.

SQL Sentry Report Parameters

Exporting Reports

SQL Sentry Reports are exported in a variety of formats for distribution purposes. After a report is run, from the Report Viewer screen, select the Export icon on the toolbar to export a report. 

SQL Sentry Exporting Reports

Report Deployment

Deploy any SQL Sentry report to one or more Reporting Services 2005 and above servers. Deploy reports to your own SSRS instance to create custom deployment schedules. 

Note:  Before the reports can be deployed, specify the name of the server where you wish to deploy the reports.

Deployment Preferences

The Report Deployment Settings may be accessed from the Reports menu (Reports > Report Deployment Settings). The following Reporting Service endpoints are supported for deploying SQL Sentry Reports:

SQL Sentry Deployment Preferences

When you choose to deploy your reports, you're given the ability to decide where on your reporting server you'd like to store these reports. Select the desired folder, and then select OK. Create new folders by right-clicking on an existing folder and selecting New Folder.

Note:  Windows Authentication must be enabled to immediately run reports from the web interface.

Additional Reporting Features

FeaturesDescriptions
List ViewsAll List views inside the SQL Sentry client are easily exported.
Runtime StatsAll Runtime Stats in the SQL Sentry client are printable.
Performance GraphsAll Performance Graphs in the SQL Sentry client are printable.
Event ChainsAll Event Chain diagrams in the SQL Sentry client are printable.
Calendar ViewsAll Calendar views in the SQL Sentry client are printable.