SQL Sentry Reporting Overview

Introduction

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.

SQL Sentry Report Viewer

All reports are accessed from the Reports menu.

SQL Sentry Reports can be deployed to the Reporting Services 2005 and above server for distribution. Report DeploymentSettings 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 > ReportDeploymentSettings). The following Reporting Service endpoints are supported for deploying SQL Sentry Reports:

SQL Sentry Deployment Preferences

Change the <Server Name> token in Deployment Preferences to your desired server name to view reports for that server. For example, in the image above, the Report Server name is "localhost" in the syntax http://localhost/ReportServer/ReportService2010.asmx. If you are unsure of your report server name, in Windows go to Report Server Configuration Manager > Database > SQL Server Name to view your server name.

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

Features	Descriptions
List Views	All List views inside the SQL Sentry client are easily exported.
Runtime Stats	All Runtime Stats in the SQL Sentry client are printable.
Performance Graphs	All Performance Graphs in the SQL Sentry client are printable.
Event Chains	All Event Chain diagrams in the SQL Sentry client are printable.
Calendar Views	All Calendar views in the SQL Sentry client are printable.