Negeate Objects from Filter Nodes (SQL)

motifu

Hi,

 

i would like to negate objects (such as DB's with high Memory utilization) from the "Nodes with High Memory Utilization" view,

any idea ?

 

Sagi

yaquaholic

Motifu,

Why not create a Custom Property (such as "isDB" = true/false ) and assigning it to all of your databases you want excluded, then filter on that custom property?

If you have a look at http://www.solarwinds.com/documentation/orion/docs/orionfiltersyntax.pdf you will find:

Filtering by Custom Property The data types that support custom properties are: 

• Interface
• Node
• Volume

Use the SWQL alias for these data types when selecting custom properties for your queries.

The property syntax to filter by custom property is: alias.CustomProperties.propertyName

Example filter to only show nodes with the custom property City that matches Atlanta:

                                       Node.CustomProperties.City = 'Atlanta'

                                       OR (if you created the "isDB" custom property)

                                       Node.CustomProperties.isDB = 0                                  (i.e.Exclude nodes where isDB = 1)

I hope it helps,

Yaquaholic