...
- 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
andreports
. - Click the Test Connection button.
A message will appear confirming if Tableau was able to connect to the DataStore, as shown below:
- Select the uptime database from the dropdown menu.
Select the Custom SQL option and enter 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,
eperformance_aggregate p, entity
ide where s.id = p.sample_
idid and e.entity_id = s.uptimehost_
nameid 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.
...