Contents
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 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 DataStore. For more information, see Connecting to the up.time DataStore via ODBC.
To configure a report in Crystal Reports:
The following window should appear:
The Data Source Selection window should appear:
reports
and reports
and then click Finish.The Add Command to Report window should appear.
Enter the following code in the column in the left portion of the window:
select e.display_name, avg(p.cpu_usr + p.cpu_sys + p.cpu_wio), DATE(s.sample_time) from performance_samples, performance_aggregate p, entity e where s.id = p.sample_id and e.entity_id = s.uptimehost_id and s.sample_time > "2010-11-23" and s.sample_time < DATE_ADD("2010-11-23", INTERVAL 7 DAY) group by DATE(s.sample_time), e.display_name order by DATE(s.sample_time), e.display_name; |
This example will report on the CPU workload average for all systems over the seven day period from 2010-11-23 to 2010-11-30.
The Standard Report Creation Wizard will start.
Use the Wizard to control the appearance of the report.
display_name
to group the systems by their host names, and then click Next.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 field column. Crystal Reports will now generate the report, as shown below:
You may need to move or alter some of the report fields to meet your desired format. |
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:
Click OK when you are finished.