Filter Hardware Health Overview

phillipcpatton

I would like to filter the Hardware Health Overview widget by a custom field "City". Is this possible?

I have a SQL script to display data but can't select output and see groups like with the widget and no color just not as good.

Regards,

Here is the SQL script I'm using to start process:

SELECT
APM_HardwareAlertData.HardwareStatus, Nodes.Caption AS NodeName

FROM
Nodes INNER JOIN APM_HardwareAlertData ON (Nodes.NodeID = APM_HardwareAlertData.NodeId)
WHERE
(
(Nodes.City = 'AUHS -Augusta University Health System')
)

GROUP BY
Nodes.Caption, APM_HardwareAlertData.HardwareStatus

ORDER BY APM_HardwareAlertData.HardwareStatus DESC

Anyone got any ideas?

Thanks