Custom SQL filter is incorrectly formatted NPM 12.0.1

Hi,

I'm trying to create a page\view which will have information on a different server in each column so I'm using the custom SQL filer but I keep getting Custom SQL filter is incorrectly formatted it appears the formatiing has changed but the show list of Volume properties you can plus out hasn't been updated?

I've read these but the links the top one points to longer exist.

https://thwack.solarwinds.com/thread/98248

https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/NPM_12_bug%3A_Custom_SQL_filter_is_incorrectly_formatted

and the 2nd one is a bug that has been fixed in the latest version but they do suggest that the table names have changed.

Does anyone know how to format this in NPM 12.0.1

I'm trying to do something like

VolumeID = 'xxxxx' or VolumeIndex = 'xxxxx'

Although I'm not sure how to find out what the volume index is either!

Thanks for any help,

worto.

Find more posts tagged with

custom sql filter

npm 12.0.1

Accepted answers

All comments

tony.johnson

hi worto03

I usually find the Custom Table and Custom Chart Resources are a good solution when running into difficulty filtering resources.

Have you tried those?

d09h

Or a cool SWQL query that someone else has crafted, needing only minimal customization. When I had queries stop working between versions, I quickly became a fan on SWQL.

FormerMember

Also encountering this problem currently...

lag

I'm running into this now in 12.2. On a few of mine, removing NodesCustomProperties.Property so all you have is your property works.

For example:

Old filter:

Vendor != 'Windows' AND Device_Type LIKE '%Server%' AND VolumeType IN ('Fixed Disk','Network Disk') AND (NodesCustomProperties.NOC = 1 OR NodesCustomProperties.AST = 1)

New Filter:

Vendor != 'Windows' AND Device_Type LIKE '%Server%' AND VolumeType IN ('Fixed Disk','Network Disk') AND (NOC = 1 OR AST = 1)

This (above) works as a filter, but the problem would come up in some cases where custom properties exist the same for Nodes, Volumes, Applications, and I need to filter at more than one element type.

rajasekar

How can i apply filter for interface custom property in SQL query report ??