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
Store

How to alert on a node that isn't monitoring the "CPU & Memory" resource

I've recently taken over monitoring responsibilities and I've noticed some of our Linux machines are not collecting CPU and memory data/statistics (when I "list resources" I see the "CPU and memory" checkbox is unchecked). How can I configure an alert for this? I've been hacking away at the "trigger condition" but can't seem to find a condition that will notify me when a particular metric/resource is not being collected.

screenshot1.png

Find more posts tagged with

Accepted answers

mesverrum

I'm going to discourage you from building this as an alert, just because every place I have ever seen someone set this kind of info up in an alert they get annoyed by all the short term blips and spam it generates.

You are much better off using a report to spot check these periodically, on my admin dashboard I have a Custom Query widget similar to this one that lets me know about any nodes where the cpu poller is turned off. The only place it can get a bit iffy is when there are multiple custom CPU pollers that a device matches against, because the default ones will show as being off when the custom one is on.

select distinct n.Caption, n.detailsurl as [_linkfor_Caption], n.machinetype  
,'List' AS [Resources]  
,'/Orion/Nodes/ListResources.aspx?Nodes=' + ToString(n.NodeID) AS [_LinkFor_Resources]  
,'/Orion/images/nodemgmt_art/icons/icon_list.gif' as [_IconFor_Resources]  
, case when cpu.pollertype is null then 'N/A'  
else cpu.pollertype   
end as [CPU and Memory] 
,cpu.enabled as [Enabled]
,case when cpu.enabled='true' THEN '\NetPerfMon\images\Small-Green.gif'  
when cpu.enabled='False' THEN '\NetPerfMon\images\Small-Red.gif'  
when cpu.enabled is null THEN '\NetPerfMon\images\Small-Shutdown.gif'  
end as [_iconfor_CPU and Memory]  

from orion.Nodes n  
left join Orion.Pollers [cpu] on n.NodeID=cpu.NetObjectID and CPU.PollerType like 'n.cpu%'  

where cpu.Enabled is not null
--and n.caption like '%${SEARCH_STRING}%'
order by n.caption

All comments

mesverrum

select distinct n.Caption, n.detailsurl as [_linkfor_Caption], n.machinetype  
,'List' AS [Resources]  
,'/Orion/Nodes/ListResources.aspx?Nodes=' + ToString(n.NodeID) AS [_LinkFor_Resources]  
,'/Orion/images/nodemgmt_art/icons/icon_list.gif' as [_IconFor_Resources]  
, case when cpu.pollertype is null then 'N/A'  
else cpu.pollertype   
end as [CPU and Memory] 
,cpu.enabled as [Enabled]
,case when cpu.enabled='true' THEN '\NetPerfMon\images\Small-Green.gif'  
when cpu.enabled='False' THEN '\NetPerfMon\images\Small-Red.gif'  
when cpu.enabled is null THEN '\NetPerfMon\images\Small-Shutdown.gif'  
end as [_iconfor_CPU and Memory]  

from orion.Nodes n  
left join Orion.Pollers [cpu] on n.NodeID=cpu.NetObjectID and CPU.PollerType like 'n.cpu%'  

where cpu.Enabled is not null
--and n.caption like '%${SEARCH_STRING}%'
order by n.caption

mikeeh24

Thank you so much Marc! This works great. I just added a where condition of 'and cpu.Enabled="false"' and that gave me exactly what I needed! It be great though if I didn't have to write a complex SWQL statement to find this out.

mikeeh24

Actually @mesverrum , I'm getting about ~150 nodes that don't show up in the result of your query (out of my ~1700 linux nodes). If I list the resources on one of those missing nodes it doesn't have "CPU and memory" checked. Once I check it it will show up in your query result. Any ideas? Seems there may be some missing data in the tables and we need to account for that.

mikeeh24

@mesverrum It seems the ~150 missing nodes do not have any "cpu.%" records in the Orion.Pollers table. Any suggestions on how I can add an OR statement so that a machine is returned if does not have any "n.cpu%" record in the Orion.Pollers table?

mesverrum

if they don't show up then you can remove the cpu.enabled is not null, that will probably get them.

As for a bulk way to fix those you might be able to just grab all their IP's and run a discovery against them.