Article Contents
Overview
Although up.time has powerful reporting features, you may want to generate reports in a custom format with a specific set of user-defined data. Microsoft Reporting Services allows you to take data from an MS SQL Server DataStore and use that data to create a report that addresses your specific needs.
Before You Begin
This article assumes that you have installed Microsoft Reporting Services and its pre-requisites:
Please also refer to Running up.time on MS SQL Server.
Setting up a Database Connection
To set up a database connection:
The following window appears:
Configuring a Report using Microsoft Reporting Services
To configure a report in Microsoft Reporting Services:
The Report Wizard starts.
SELECT e.display_name AS 'Description',AVG(p.cpu_usr + p.cpu_sys + p.cpu_wio) AS 'CPU Workload Average',(CONVERT(char(10),s.sample_time,102)) AS 'Date' FROM performance_sample s, performance_aggregate p, entity e WHERE s.id = p.sample_id AND e.entity_id = s.uptimehost_id AND s.sample_time > '2006.11.29' AND s.sample_time < DATEADD(day,5,'2006.11.29') GROUP BY (convert(char(10),s.sample_time,102)), e.display_name ORDER BY (convert(char(10),s.sample_time,102)), e.display_name;
This example will report on the CPU workload average for all systems over the five day period from 2006-11-29 to 2006-12-03 (simply change the dates or the interval as required).
The Design the Matrix window appears, which enables you to change the way in which data is arranged in the report.
In this example:
The Design the Matrix window appears.
Publishing a Report to IIS
When you are satisfied with your report, you can publish it to IIS (Internet Information Server, a Web server that runs under Windows) by completing the following steps:
TargetServerURL
to the URL where Reporting Services has been installed. For example, http://localhost/ReportServer.
After the report has been published, your default Web browser will automatically open in the directory in which the report was published. Click on the file name of the report to open it.
Note: Published reports may not render properly in web browsers other than Internet Explorer. If, for example, you have set your default browser to Firefox and the report does not open properly after you have published it, copy and paste the URL of the report into Internet Explorer. You can also view the report by navigating to the Report Manager URL in Internet Explorer. By default, the URL is http://localhost/Reports/Pages/Folder.aspx
.