Custom Query Help

stephenh88

1. Hi

Wonder if someone can help. Within our NPM dashboard we have a widget displaying servers whos disk space is over 90%. The query we have is VolumePercentUsed >= 90 AND VolumeType LIKE 'Fixed Disk'.

Within this widget it is displaying servers that we want filtered out. We have custom properties attached to the servers which we want to filter these out by. The custom property is Company_Division and the Value is Retail estate.

What I am looking for is the widget to show all servers with disk space over 90% but to filter out those in the retail estate.

shuth

You can use something like the following query. The IS NULL part will include any node that has an empty Company_Division value (or you can use IS NOT NULL)

VolumePercentUsed >=90 AND VolumeType LIKE 'Fixed%' AND (Nodes.CustomProperties.Company_Division = 'Retail estate' OR Nodes.CustomProperties.Company_Division IS NULL)

Or if you don't want the Retail Estate nodes;

VolumePercentUsed >=90 AND VolumeType LIKE 'Fixed%' AND (Nodes.CustomProperties.Company_Division <> 'Retail estate' OR Nodes.CustomProperties.Company_Division IS NULL)