SentryOne offers an expansive list of reporting options, and reports are generated using SQL Server Reporting Services (SSRS) technology. The SentryOne client includes the Reporting Services Report Viewer that allows the SentryOne reports to be viewed from within the SentryOne client. All reports are accessed from the Reports menu.
SentryOne 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 SentryOne Reports, see the Reports topic.
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.
SentryOne 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.
Deploy any SentryOne 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.
The Report Deployment Settings may be accessed from the Reports menu (Reports > Report Deployment Settings). The following Reporting Service endpoints are supported for deploying SentryOne Reports:
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.
To create a subscription for any of the SentryOne reports, you'll need to adjust the instance properties of the SQL Data Source SQLDS. In your cloud.sentryone.com account, navigate to the Server Details for the database you wish to configure reports for, and then select Reports from the Navigator pane. Select the email icon in the upper right-hand corner next to the report you wish to subscribe to, set parameters, as well as where to send the report, and then select Save.
You become the owner when you create a Report Subscription, so only you can edit or delete it. For more information about Report Subscriptions, see this Report Subscription post on our blog.
Additional Reporting Features
|List Views||All List views inside the SentryOne client are easily exported.|
|Runtime Stats||All Runtime Stats in the SentryOne client are printable.|
|Performance Graphs||All Performance Graphs in the SentryOne client are printable.|
|Event Chains||All Event Chain diagrams in the SentryOne client are printable.|
|Calendar Views||All Calendar views in the SentryOne client are printable.|
Importing a Report
Select Import Report in the Reports menu. SentryOne supports importing future reports, created by the SentryOne development team, to the client separately without requiring an upgrade.