Date: Thu, 28 Mar 2024 13:38:23 +0000 (UTC) Message-ID: <910657422.5381.1711633103089@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5380_505017562.1711633103086" ------=_Part_5380_505017562.1711633103086 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Contents
While Uptime Infrastructure Monitor offers powerful reporting features, = you may want to generate reports that use a specific set of data or a custo= m report format. Using Crystal Reports, you can retrieve data from the up.t= ime DataStore and use it to create reports that meet your individual requir= ements.
If you have not already done so, install the MySQL ODBC driver and creat= e a data source to access the up.time DataStore. For more information, see = Conn= ecting to the up.time DataStore via ODBC.
To configure a report in Crystal Reports:
The = following window should appear:
The Data Source Selection window sh= ould appear:
reports
an=
d reports
and then click Finish.The Add Command to Report wind= ow should appear.
Enter the following code in the column in the left portion of the wi= ndow:
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 =3D p.sample_id and e.entity_id =3D 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 syste= ms over the seven day period from 2010-11-23 to 2010-11-30.
The Standard = Report Creation Wizard will start.
Use the Wizard to contr= ol the appearance of the report.
display_name
to group the s=
ystems 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. Cryst= al Reports will now generate the report, as shown below:
Note
Download the sample report that was created earlier, open it locally wit= h the settings intact and then modify the sample report as required by foll= owing these steps:
Click OK when you are finished.=