Page History

...

• Internet Information Server (IIS) with ASP.NET
• SQL Server
• Visual Studio .NET

Please also refer to Running UIM Uptime Infrastructure Monitor with an Oracle database.

Setting up a database connection

To set up a database connection:

1. Start Microsoft Visual Studio .NET, and then choose

...

1. File > New > Project. The

...

1. New Project window appears

...

1. .
   Image Added
2. In the Project Types tree, select the Business Intelligence Projects folder

...

1. .
2. In the Templates area, select the

1. Report Project template

...

1. .

...

1. In the Name field, type a name for your report

...

1. , and then click OK.
2. Click the View / Solutions Explorer button to open the Solution Explorer window.
3. Right-click Shared Data Sources, and then select Add New Data Source.
4. In the Data Link Properties window, click the Provider tab.
   Image Added
5. Double-click Microsoft OLE DB Provider for SQL Server, which opens the Data Link Properties window on the Connection tab.
   Image Added

...

1. Type the name of the database server, and then use the user name

...

1. and password combination needed to

...

1. log in to the server.
2. Click

...

1. Test Connection

...

1.  to verify that you can establish a connection to the database.
2. Choose the database from which you want to retrieve the data

...

1. , and then click OK.

Configuring a report using Microsoft Reporting Services

To configure a report in Microsoft Reporting Services:

1. In Microsoft Visual Studio .NET, right-click Reports, and

...

1. select Add New Report. The Report Wizard starts.

...

1. Click Next.
2. Select Shared data source, and then select the database from which you are retrieving data.
   Image Added
3. Click Next.
4. Enter the following query string:
   

   Code Block
   language sql
   SELECT e.display_name AS 'Description',

...

1. AVG(p.cpu_usr + p.cpu_sys + p.cpu_wio) AS 'CPU Workload Average',(CONVERT(char(10),s.sample_time,102)) AS 'Date'

...

1. FROM performance_sample s, performance_aggregate p, entity e WHERE s.id = p.sample_id

...

1. AND e.entity_id = s.uptimehost_id AND s.sample_time > '

...

1. 2023.11.29'

...

1. AND s.sample_time < DATEADD(day,5,'

...

1. 2023.11.29')

...

1. 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

...

1. reports on the CPU workload average for all systems over the five day period from

...

1. 2023-11-29 to

...

1. 2023-12-03 (simply change the dates or the interval as required).
2. Click Next after you change the range to suit your needs.
3. Choose the Matrix option, and then click Next.
   Image Added
   The Design the Matrix window appears, which enables you to change the way in which data is arranged in the report.
4. In this example:
   • Description is moved to the Rows field.
   • Date is moved to the Columns field.
   • CPU Workload Average is moved to the Details field.
5. Click Next.
6. In the Choose Matrix Style window, select Compact. The Design the Matrix window appears.
   Image Added
7. Select to display all of the fields in the report, and then click Next.
8. Click the Preview Report check box at the bottom of the page.
   Image Added
9. Click Finish to generate a preview of the report.

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:

1. In Microsoft Visual Studio .NET, access the Solutions Explorer to open Solution Explorer.
2. Right-click the current project, and then select Properties.
3. In the Properties window, change the value of TargetServerURL to the URL where Reporting Services

...

1. is installed. For example, http:

...

1. //localhost/ReportServer.
   Image Added
2. Click OK.
3. In the Solutions Explorer, click Debug / Start to publish the report.
4. After the report

...

1. is published, your default Web browser

...

1. automatically

...

1. opens in the directory in which the report was published. Click

...

1. the file name of the report to open it.
   Image Added
2. You can also export the report from your web browser by selecting a format from the dropdown list, as shown below:
   Image Added
   

   Info

   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.