Page History

...

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 Uptime Infrastructure Monitor DataStore via ODBC Knowledge Base article.

Configuring a

...

report in Tableau

To configure a report in Tableau:

1. Start Tableau.
2. Select Data, and then click Connect to Data Source.
3. Double-click New Connection.
4. Choose MySQL Database.
5. In the Enter a Server name field, type the name of the server that is hosting the DataStore that to which you want to connect to.
6. Enter Type the port on which the DataStore is listening in the Port field (the . The default port for the DataStore is 3308).
7. In the Username and Password fields, enter reports and reports.
8. Click the Test Connection button. A message will appear appears confirming if whether Tableau was is able to connect to the DataStore, as shown below.
   IMAGEImage Added
9. Select the uptime appropriate database from the dropdown menu.
10. Select the Custom SQL option, and enter then type the following statement in the text area:
    

    Code Block
    language sql
    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

    2023-11-17"

    and s.sample_time < DATE_ADD("

    2010

    2023-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 reports on the CPU workload average for all systems over the 7-day period from 20102023-11-17 to 20102023-11-24.
11. 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:

IMAGEImage Added

In the above example, display_name and avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) are moved into Rows by clicking with the mouse, click, hold, and dragging the values from the left-hand column, and then dropping them in into the Rows field. DATE(s.sample_time) is moved moves to Columns in a similar way. By default, Tableau may format the DATE(s.sample_time) to only display the year, and format avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) to add the results.

To change this presentation, hold your mouse over any of the fields, and then click the arrow that appears on the right side of the field to open the following menu:

IMAGEImage Added

Select All Values from the menu for both the display_name and avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) fields (you . You may need to move or alter some fields to modify the default Tableau formatting).

The following image illustrates a formatted Tableau report:

IMAGEImage Added