Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SWQL Query Filter on Memory Utilization Resource

Hello,

Is there a way to have a nested filter in the SWQL filter field on the Memory Utilization resource? I tried the following and it threw an error.

PercentMemoryUsed > 85 AND (Caption Not Like '*WIN' AND Node.CustomProperty.Region Not Like 'Southern')

What I want it to do is show servers with 85% memory usage and filter out server captions that end with 'WIN' and the Node Custom Property Region is not 'Southern'. How would I be able to get this working like I described?

@KMSigma.SWI

Thanks

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

I think your syntax is just a little off.

The 'wildcard' for SWQL is % not *. Try this out:

PercentMemoryUsed > 85 AND (Caption NOT LIKE '%WIN' AND Node.CustomProperty.Region <> 'Southern')

Also - since you are using all "AND" as your connectors, there's no reason for the parenthesis.

bharris1

If you don't use parenthesis won't it filter out all the *WIN servers and all "Southern" servers? I want it to show all servers with 85%+ and filter out only the "*WIN" servers that aren't part of the "Southern" region.

KMSigma.SWI

No, that's not the way that boolean operations work.

bharris1

Thanks for the clarification. I just dropped that into the filter and I'm getting "Custom SWQL filter is incorrectly formatted" in the resource.

KMSigma.SWI

If you add a "Custom Query" resource to your page you can put this in the "Query" details:

SELECT [Nodes].Caption
, '/Orion/images/StatusIcons/Small-' + [Nodes].StatusIcon AS [_IconFor_Caption]
, [Nodes].PercentMemoryUsed
, [Nodes].DetailsUrl AS [_LinkFor_Caption]
FROM Orion.Nodes AS [Nodes]
WHERE PercentMemoryUsed > 5
AND Caption LIKE '%NAS%'
AND [Nodes].CustomProperties.Region = 'Southern'
ORDER BY [Nodes].PercentMemoryUsed DESC

And then submit. You should get what you'd expect. This is tested on Platform 2020.2.4, so I can't guarantee backward compatibility.