Page History

While Uptime Infrastructure Monitor offers powerful reporting features, you may want to generate reports that use a specific set of data or a custom report format. Using Crystal Reports, you can retrieve data from the up.time UIM DataStore, and use it to create reports that meet your individual requirements.

...

If you have not already done so, install the MySQL ODBC driver and create a data source to access the up.time UIM DataStore. For more information about this feature, see Connecting to the up.time Uptime Infrastructure Monitor DataStore via ODBC.

Configuring a report in Crystal Reports

To configure a report in Crystal Reports:

1. Start Crystal Reports, and then click the Standard Report Wizard icon. The following window should appear:
   Image Added
2. In the Data Source column

...

1. , expand the Create New Connection and ODBC (RDO) folders.
2. Double-click Make New Connection.

...

1. The Data Source Selection window should appear:
   Image Added
2. In the Data Source Name list, click

...

1. your UIM version, and then click Next.
2. When prompted for a user ID and password, enter reports

...

1. in both fields, and then click Finish.

...

1. The connection

...

1. appears in the Make New Connection window.
2. Expand the connection, and then double-click Add Command. The Add Command to Report window

...

1. appears.

...

1. Type the following code in the column in the left portion of the window:
   

   Code Block
   language sql
   select e.display_name,

...

1. avg(p.cpu_usr + p.cpu_sys + p.cpu_wio), DATE(s.sample_time)

...

1. from performance_samples, performance_aggregate p, entity e

...

1. where s.id = p.sample_id

...

1. and e.entity_id = s.uptimehost_id and s.sample_time > "

...

1. 2023-11-23"

...

1. and s.sample_time < DATE_ADD("

...

1. 2023-11-23", INTERVAL 7 DAY) group by DATE(s.sample_time), e.display_name

...

1. order by DATE(s.sample_time), e.display_name;

   
   This example

...

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

...

1. 2023-11-23 to

...

1. 2023-11-30.
2. Click OK after you change the range to suit your needs. The Standard Report Creation Wizard

...

1. starts.
   Image Added
   Use the

...

1. wizard to control the appearance of the report.
2. Select the fields that you want to display in the report, and then click Next.
3. On the Grouping screen, select display_name to group the systems by their host names, and then click Next.
   Image Added
4. On the Summaries screen, select avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) from the Available Fields column, and then select Average from the drop-down list below the Summarized

...

1. Fields column.
   Image Added
2. Click Next.
3. Select None for group ordering, and then click Next.
4. Select No Chart, and then click Next.
5. Do not choose any subset information to display, and then click Next.
6. Select the template that you want to use, and then click Finish. Crystal Reports

...

1. now

...

1. generates the report, as shown below:
   Image Added
2. Save the report by selecting Save from the File menu.
   

   Info
   You may need to move or alter some of the report fields to meet your desired format.

Modifying the

...

sample report

Download the sample report that was created earlier, open it locally with the settings intact, and then modify the sample report as required by following these steps:

1. Download the sample report using the link to the right.
2. Open the file in Crystal Reports.
3. Click Database / Set Datasource Location.
4. In the Set Datasource Location window, click

...

1. the current data source.
   Image Added
2. Locate your ODBC source in the bottom part of the window, click Update, and then click Close.
3. Click

...

1. Database / Database Expert.
2. In the Selected Tables column, right-click

...

1. Command, and choose Edit Command.
   Image Added
2. Modify the report to suit your needs.

...

2. Click OK when you are finished.