Filter 'Top 10' Resources to Show only Warning/Critical

jdumke

I have a request from a colleague to modify the TOP 10 view so that it only shows "Yellow" and "Red".

1) Better Way to Filter Based on Threshold Variables?

Some of the resources are easy to filter - like "Top xx Nodes by Current Response Time"

Filter = ResponseTime > 500

But, is there a better way of doing by using a variable like:

Filter = ResponseTime > WarningThreshold

2a) Some I can't figure out how to best filter:

I want to filter "Top 10 Nodes by Percent Memory Used" based on "VolumePercentUsed" because it looks to me as if this resource is based on Physical Memory Used.

But, I get the dreaded SQL syntax error every time I try to use VolumePercentUsed.

I resorted to this but it's not 100% accurate because it's based on the Node's Memory instead of the Physical Memory:

Filter = status <> 1 and PercentMemoryUsed >=97

I tried VolumePercentUsed, Volumes.VolumePercentUsed and both give the SQL Syntax error.

2b) "Top XX Monitored Processes by CPU Load"

I can't figure out how to get the value for the monitoredprocesses' CPULoad?

2c) "Top XX Components by Response Time"

Similarly, I can't figure out how to get the Response Time for the Component to filter by?

Find more posts tagged with

resource filter

resource_filter

Accepted answers

mesverrum

The default resources have some limitations to the filtering they can do and don't have the capability to just bounce around all over the database (those thresholds you want are on another table). If you are willing to get comfortable with SWQL you could set up a custom query like this to get a similar result but you would lose the bar graphs and have to rely on more crude images to get color into it, but you have much more control of the filters you can create

select n.caption as [Node],n.detailsurl as [_linkfor_Node],'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node], n.PercentMemoryUsed, CASEWHEN n.PercentMemoryUsed < t.Level2Value THEN '/Orion/images/StatusIcons/Small-warning.gif'WHEN n.PercentMemoryUsed >= t.Level2Value THEN '/Orion/images/StatusIcons/Small-critical.gif'END as [_iconfor_PercentMemoryUsed]from orion.nodes njoin Orion.PercentMemoryUsedThreshold t on t.instanceid=n.nodeidwhere n.PercentMemoryUsed > t.Level1Valueorder by n.PercentMemoryUsed desc

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

All comments

chad.every

i think what I have done for top XX volumes might address 2a. I'm using the Top XX Volumes by Disk Spcae Used and this is the Filter Syntax:

VolumeDescription Not Like 'real memory*' And VolumeDescription Not Like 'Physical Memory*' and VolumeDescription Not Like 'virtual memory*'

A lot of times i'll create a Custom Table resource and that gives me the option to 'select datasource' and use the dynamic query builder to get what i'm looking for.

mesverrum

select n.caption as [Node],n.detailsurl as [_linkfor_Node],'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node], n.PercentMemoryUsed, CASEWHEN n.PercentMemoryUsed < t.Level2Value THEN '/Orion/images/StatusIcons/Small-warning.gif'WHEN n.PercentMemoryUsed >= t.Level2Value THEN '/Orion/images/StatusIcons/Small-critical.gif'END as [_iconfor_PercentMemoryUsed]from orion.nodes njoin Orion.PercentMemoryUsedThreshold t on t.instanceid=n.nodeidwhere n.PercentMemoryUsed > t.Level1Valueorder by n.PercentMemoryUsed desc

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

mesverrum

Also, I just tried it out a few ways myself and it seems like the syntax they have in the SAM SQL syntax help must not be correct because I could get it to load without syntax errors using their recommendations (pe.AvgPercentCPU) but it wouldnt match any of my components in my environment, even when i did things that should always be true like >0. Maybe someone from SW will weigh in on that but I'd just use more custom queries for that until then.

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems