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

Show Node Thresholds on NodeDetails View

bardeev

Hi all!!!

Anybody knows how add Node Thresholds on view?

Users without admins rights can't edit nodes, but they needed to see thresholds.

Find more posts tagged with

thresholds

Accepted answers

i_like_eggs

hey,

this should do the job:

create a custom query resource paste the SWQL:

select t.name as  Alerting_Thresholds,t.level1value AS Warning,t.level2value AS CricitalFROM Orion.Thresholds t INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId Where t.name IN('Nodes.Stats.CpuLoad','Nodes.Stats.ResponseTime','Nodes.Stats.PercentMemoryUsed','Nodes.Stats.PercentLoss') AND (n.nodeID = ${NodeID})

Extra:

i tried to get a case statement to work to change the names but it wasnt playing ball

if your interested or if any one knows why this doesn't work please hit me up:

select case t.name when 'Nodes.Stats.CpuLoad' then 'CPU' when 'Nodes.Stats.ResponseTime' then 'ResponseTime' when 'Nodes.Stats.PercentMemoryUsed' then 'PercentMemoryUsed'when 'Nodes.Stats.PercentLoss' then 'PercentLoss'END as Alerting_Thresholds,n.nodeid,t.level1value AS Warning,t.level2value AS CricitalFROM Orion.Thresholds t INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId Where t.name IN('Nodes.Stats.CpuLoad','Nodes.Stats.ResponseTime','Nodes.Stats.PercentMemoryUsed','Nodes.Stats.PercentLoss') AND (n.nodeID = ${NodeID})

hope that helps

All comments

i_like_eggs

hey, try this:

bardeev

Thanks.

But I need this

roelb

I think the gauges on the Vital stats tab show the thresholds.

i_like_eggs

hey,

this should do the job:

create a custom query resource paste the SWQL:

select t.name as  Alerting_Thresholds,t.level1value AS Warning,t.level2value AS CricitalFROM Orion.Thresholds t INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId Where t.name IN('Nodes.Stats.CpuLoad','Nodes.Stats.ResponseTime','Nodes.Stats.PercentMemoryUsed','Nodes.Stats.PercentLoss') AND (n.nodeID = ${NodeID})

Extra:

i tried to get a case statement to work to change the names but it wasnt playing ball

if your interested or if any one knows why this doesn't work please hit me up:

select case t.name when 'Nodes.Stats.CpuLoad' then 'CPU' when 'Nodes.Stats.ResponseTime' then 'ResponseTime' when 'Nodes.Stats.PercentMemoryUsed' then 'PercentMemoryUsed'when 'Nodes.Stats.PercentLoss' then 'PercentLoss'END as Alerting_Thresholds,n.nodeid,t.level1value AS Warning,t.level2value AS CricitalFROM Orion.Thresholds t INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId Where t.name IN('Nodes.Stats.CpuLoad','Nodes.Stats.ResponseTime','Nodes.Stats.PercentMemoryUsed','Nodes.Stats.PercentLoss') AND (n.nodeID = ${NodeID})

hope that helps

bardeev

It looks like what i need.

This query works fine in SWQL Studio, but this query doesn't work on NodeDetails page.

Anybody knows how filter by current Node?

In SWQL Studio ${NodeID} shows thresholds for all nodes.

But in web query failed.