Article Contents
\nOverview
\n \nWhile up.time 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.
\n \nBefore You Begin
\n \nIf 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.
\n \nConfiguring a Report in Crystal Reports
\n \nTo configure a report in Crystal Reports:
\nThe following window should appear:
\n \nThe Data Source Selection window should appear:
\n \nreports
and reports
and then click Finish.The Add Command to Report window should appear.
\n\nselect e.display_name,avg(p.cpu_usr + p.cpu_sys + p.cpu_wio), \n DATE(s.sample_time) from performance_samples, \nperformance_aggregate p, entity e \nwhere s.id = p.sample_id \nand e.entity_id = s.uptimehost_id \nand s.sample_time > "2010-11-23" \nand s.sample_time < DATE_ADD("2010-11-23", INTERVAL 7 DAY) \ngroup by DATE(s.sample_time), e.display_name \norder by DATE(s.sample_time), e.display_name; \n\n \n
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.
\nThe Standard Report Creation Wizard will start.
\n \nUse the Wizard to control the appearance of the report.
\ndisplay_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 dropdown list below the Summarized field column.
\nCrystal Reports will now generate the report, as shown below:
\n \nNote: You may need to move or alter some of the report fields to meet your desired format.
\n \nModifying the Sample Report
\n \nDownload 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:
\nClick OK when you are finished.
\n