cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Filter Hardware Health Overview

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

0 Kudos
0 Replies