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.
Here is the SQL script I'm using to start process:
APM_HardwareAlertData.HardwareStatus, Nodes.Caption AS NodeName
Nodes INNER JOIN APM_HardwareAlertData ON (Nodes.NodeID = APM_HardwareAlertData.NodeId)
(Nodes.City = 'AUHS -Augusta University Health System')
ORDER BY APM_HardwareAlertData.HardwareStatus DESC
Anyone got any ideas?