Nodes with Problems: How to filter out hardware health 'fans running at full speed'

hilbertd21

Trying to create a custom SQL query under Nodes with Problems resource, where I can filter out chassis fans listed under hardware health as 'Fans running at full speed'

Here's what shows up node description.

..and here's the node details drill down of the condition I want to filter out.

I was able to create a filter using: statusdescription not like '%Warning%', which is basically filtering out anything at Warning level, which is too broad. I've also tried : status not like '%Running at full speed%', which fails.

Where would I find the exact syntax to drill down to this one? You know, something like CurrentHardwareHealth.Status not like '%Running at full speed%'

ObjectSubType?!? Entity Type?!?

chefwear

I, too, need to know the SWQL syntax for digging into CurrentHardwareHealth. Someone tell us how to query CurrentHardwareHealth.