Page History
Table of 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 Tableau, you can retrieve data from the up.time UIM DataStore and use it to create reports that meet your individual requirements.
For a functional example of how you can use Tableau to create reports, see this posting on the Uptime Community Forum.
Before you begin
If you have not already done so, install the MySQL ODBC driver and create a data source to access the UIM DataStore. For more information, see the Connecting to the up.time DataStore via ODBC Knowledge Base article.
Configuring a Report in Tableau
To configure a report in Tableau:
- Start Tableau.
- Select Data and then click Connect to Data Source.
- Double click New Connection.
- Choose MySQL Database.
- In the Enter a Server name field, type the name of the server that is hosting the DataStore that you want to connect to.
- Enter the port on which the DataStore is listening in the Port field (the default port for the DataStore is 3308).
- In the Username and Password fields, enter reports and reports.
- Click the Test Connection button. A message will appear confirming if Tableau was able to connect to the DataStore, as shown below.
IMAGE - Select the uptime database from the dropdown menu.
- Select the Custom SQL option and enter the following statement in the text area:
- select e.display_name,
- avg(p.cpu_usr + p.cpu_sys + p.cpu_wio), DATE(s.sample_time)
- from performance_sample s, performance_aggregate p, entity e
- where s.id = p.sample_id
- and e.entity_id = s.uptimehost_id and s.sample_time > "2010-11-17"
- and s.sample_time < DATE_ADD("2010-11-17", INTERVAL 7 DAY) group by DATE(s.sample_time), e.display_name
- order by DATE(s.sample_time), e.display_name
- The above example will report on the CPU workload average for all systems over the 7-day period from 2010-11-17 to 2010-11-24.
- Click OK when finished.
Modifying
...
how the report displays information
You can quickly and easily change the information in a Tableau report to suit your needs, as illustrated below:
...