search

dinger1986 / TRMM-Grafana

Grafana Dashboards setup and preconfigured to work with Tactical RMM
32 stars 17 forks source link

Separate Disk Usage graph #21

Closed ventra007 closed 2 years ago

ventra007 commented 2 years ago

Hello,

Is there a way to separate multiple disks from this panel? Currently it is retrieving percentage remaining from all disks and plotting it on the graph.

2022-06-13 07_45_26-ImplyIT RMM Reporting - Grafana

2022-06-13 07_45_39-ImplyIT RMM Reporting - Grafana

As you can see, everytime it checks it pulls two records, one for each disk.

ventra007 commented 2 years ago

Figured it out. Just limited the search to only look at the C: drive

SELECT x AS "time", y as "Disk Usage" FROM checks_checkhistory, checks_check, agents_agent WHERE checks_checkhistory.agent_id=agents_agent.agent_id AND checks_checkhistory.check_id=checks_check.id AND agents_agent.hostname='$Agent' AND checks_check.disk='C:' AND x BETWEEN $timeFrom() and $timeTo() ORDER BY x