Page History

While Uptime Infrastructure Monitor has a powerful reporting function, you may want to generate reports that use a specific set of data and/or put that data into a custom report format. Using Microsoft Excel, you can take data from the UIM DataStore and use that data to create a report that specifically suits your requirements.

...

Retrieving UIM data in Excel 2010: Querying an established database connection

Follow these steps to To import data from an Uptime Infrastructure Monitor a UIM DataSource into Excel 2010:

1. Whenever you finish creating a connection profile to the up.time UIM DataStore, or open an existing connection profile, the Import Data dialog is displayed:
   Image Modified

...

1. Click Properties.

...

1. Image Removed
   The Connection Properties dialog is displayed.
2. Click the Definition tab:.
   Image Added
3. In the Command text box, enter the SQL statement that retrieves the data you wish to use in Excel. For example:
   

   Code Block
   language sql
   SELECT e.display_name, min(p.cpu_sys+p.cpu_usr+p.cpu_wio), max(p.cpu_sys+p.cpu_usr+p.cpu_wio), avg(p.cpu_sys+p.cpu_usr+p.cpu_wio), min(p.free_mem), max(p.free_mem), avg(p.free_mem)

...

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

...

1. AND s.uptimehost_id = e.entity_id

...

1. AND s.sample_time > DATE_SUB(now(), INTERVAL 7 DAY) AND s.sample_time < now()

...

1. GROUP BY e.display_name ORDER BY s.sample_time;

   This sample query retrieves CPU- and memory-related data that was collected by Uptime Infrastructure Monitor over the last seven days.
2. Click Click OK.
3. # If you are prompted with the ODBC 3.51 Connector dialog box, ensure your user and password information is correct, then click click OK.
   Once your queried data is in an Excel sheet, you can work with it as required. The example below is an inserted table displaying CPU usage highs, lows and averages for all monitored systems over the last seven days.
   Image Modified

Retrieving UIM data in Excel 2007: Creating a new database connection

...