Page History
Contents
Overview
Before You Begin
Retrieving Uptime Infrastructure Monitor Data in Excel 2010: Creating a New Database Connection Retrieving Uptime Infrastructure Monitor Data in Excel 2010: Querying an Established Database Connection Retrieving Uptime Infrastructure Monitor Data in Excel 2007: Creating a New Database Connection Retrieving Uptime Infrastructure Monitor Data in Excel 2007: Querying an Established Database Connection Retrieving Uptime Infrastructure Monitor Data in Excel 2003
| Anchor | ||||
|---|---|---|---|---|
|
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 up.time DataStore and use that data to create a report that specifically suits your requirements.
| Anchor | ||||
|---|---|---|---|---|
|
If you have not already done so, install the MySQL ODBC driver and create a data source to access the up.time DataStore. This article assumes you have performed these steps. For more information, see the Connecting to the up.time DataStore via ODBC Knowledge Base article.
| Anchor | ||||
|---|---|---|---|---|
|
Follow these steps to establish the Uptime Infrastructure Monitor DataSource as an external data source for use in Excel 2010:
...
The database name you select is the name you gave to the up.time DataStore when you created its profile in the ODBC Data Source Administrator Control Panel. The database table you select depends on the type of Uptime Infrastructure Monitor data you want to import into Excel (in this example, we are importing aggregate performance data).
- In the final Wizard step, remember the Friendly Name assigned to this connection profile, then click Finish to save the database connection profile.
Note: Now that you have created an Office database connection (.odc) file for the Uptime Infrastructure Monitor database and specified table, you will be able to use this existing connection to perform new database queries in future Excel sessions (on the Data tab, in the Get External Data group, click Existing Connections, then select the connection by clicking the Friendly Name). When you begin to work with data using an existing connection, Excel will prompt you with the Import Data dialog box, which you can use to modify your database query.
When you create a connection to the Uptime Infrastructure Monitor database for the first time, you will always be prompted with the Import Data
dialog box; this dialog box is described in the next section.
| Anchor | ||||
|---|---|---|---|---|
|
Follow these steps to import data from an Uptime Infrastructure Monitor DataSource into Excel 2010:
- Whenever you finish creating a connection profile to the up.time DataStore, or open an existing connection profile, the Import Data dialog is displayed:
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
Follow these steps to establish the Uptime Infrastructure Monitor DataSource as an external data source for use in Excel 2007:
...
The Data Connection Wizard appears:
- Select ODBC DSN as the type of data source you want to use to make a connection, then click Next.
- In the next Wizard step, select the Uptime Infrastructure Monitor ODBC data source, then click Next.
...
Note: Now that you have created an Office database connection (.odc) file for the Uptime Infrastructure Monitor database and specified table, you will be able to use this existing connection to perform new database queries in future Excel sessions (on the Data tab, in the Get External Data group, click Existing Connections, then select the connection by clicking the Friendly Name). When you begin to work with data using an existing connection, Excel will prompt you with the Import Data dialog box, which you can use to modify your database query.
When you create a connection to the Uptime Infrastructure Monitor database for the first time, you will always be prompted with the Import Data
dialog box; this dialog box is described in the next section.
| Anchor | ||||
|---|---|---|---|---|
|
Follow these steps to import data from an Uptime Infrastructure Monitor DataSource into Excel 2007:
- Whenever you finish creating a connection profile to the up.time DataStore, or open an existing connection profile, the Import Data dialog is
...
- Click OK.
- If you are prompted with the ODBC 3.51 Connector dialog box, ensure your user and password information is correct, then 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.
Retrieving Uptime Infrastructure Monitor Data in Excel 2003Follow these steps to establish the Uptime Infrastructure Monitor DataSource as an external data source for use in Excel 2003:Anchor _bookmark40 _bookmark40 - Start Microsoft Office Excel 2003.
- On the Data menu, click Import External Data, then click New Database Query.
- The Choose Data Source dialog box is displayed:
...
- Click the View menu, then click SQL to display the query. The columns you selected in the Query Wizard (step 4) will be displayed as the SQL statement:
- Edit the SQL statment to refine which of the data from the selected columns will be used in the Excel sheet, then click OK to return to Microsoft Query.
- Click File, then click Return Data to Microsoft Office Excel.
...