Lab Tech - Servers Current performance Stats for dashboard use

Follow

Hi there, now that Bright Gauge can sync often enough to make this workable ......... we display pie graphs in a dashboard to show the stats from the query below. We have separate graphs for CPU and Memory. We have drill down enabled to allow us to see which machines are showing high CPU use.
We sync this data set every 5 minutes.
Note: We have a custom Region filed so we can report on different regions.

SELECT UUID() AS 'id', vex.Region AS 'Region', cl.Name AS 'Client Name', c.name, c.computerid, c.CPUUsage, c.TotalMemory, c.MemoryAvail
, ROUND((((c.TotalMemory - c.memoryavail) / c.totalmemory) * 100), 2) AS '% Memory Used'
, CASE
WHEN ROUND((((c.TotalMemory - c.memoryavail) / c.totalmemory) * 100), 2) BETWEEN '90.0' AND '94.99' THEN '90 - 95%'
WHEN ROUND((((c.TotalMemory - c.memoryavail) / c.totalmemory) * 100), 2) BETWEEN '95' AND '97.99' THEN '95 - 98%'
WHEN ROUND((((c.TotalMemory - c.memoryavail) / c.totalmemory) * 100), 2) BETWEEN '98' AND '100' THEN '98 - 100%'
END AS 'MemStatus'
, CASE
WHEN c.CPUUsage BETWEEN '80' AND '90' THEN '80 - 90'
WHEN c.CPUUsage BETWEEN '90' AND '95' THEN '90 - 95'
WHEN c.CPUUsage BETWEEN '95' AND '100' THEN '95 - 100'
END AS 'CPUStatus'

FROM computers c
JOIN clients cl ON cl.ClientID = c.ClientID
JOIN v_extradataclients vex ON vex.ClientID = cl.ClientID
WHERE c.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE) AND c.os LIKE '%server%'