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

What nodes don't have their disk volumes monitored?

A disk on one of my servers ran out of disk and no alert triggered for it. I went to the node and clicked on List Resources where I saw that the volumes were not selected. Which leads me to my question.

Is there a query I could run to list all nodes where disk volumes are not selected? I'll poke around in the database to try and figure it out but I'm hoping someone can save me some time. Thanks!

Find more posts tagged with

SWQL

Accepted answers

jfaldmo

Thanks, guys, for the tips. This is the swql I came up with. But I'll look into the automatic discoveries.

SELECT TOP 1000 N.NodeID, N.Caption, COUNT(V.VolumeID) as CountOfVolume
FROM Orion.Nodes as N
LEFT JOIN Orion.Volumes as V ON N.NodeID = V.NodeID
WHERE N.ObjectSubType='Agent'
GROUP By N.NodeID, N.Caption
ORDER BY CountOfVolume

All comments

brscott

Here is one that I use on my personal orion view. It's a custom swql widget that shows the recently added nodes and how many monitored interfaces and volumes it has. It's usually on new nodes that people forget to add the volumes. This does not help for volumes added later to the server, but you could tweak the "where" part.

select Node, _IconFor_Node, _LinkFor_Node, Created, Volumes, Interfaces, Poller from (

SELECT TOP 1000

Caption as Node,

'/Orion/images/StatusIcons/Small-' + n.StatusLED as _IconFor_Node,

DetailsUrl as _LinkFor_Node,

(SELECT top 1 ae.ObservationTimestamp as CreatedDate FROM Orion.AuditingEvents ae Where ae.netobjecttype='N' and ae.netobjectid=N.NodeID and ae.ActionTypeID=25) as Created,

(SELECT count(VolumeID) as Volumes FROM Orion.Volumes v where v.nodeid=N.NodeID) as Volumes,

(SELECT count(InterfaceID) as Interfaces FROM Orion.NPM.Interfaces i where i.nodeid=N.nodeid) as Interfaces,

N.Engine.DisplayName as Poller

FROM Orion.Nodes N

where (SELECT top 1 ae.ObservationTimestamp as CreatedDate FROM Orion.AuditingEvents ae Where ae.netobjecttype='N' and ae.netobjectid=N.NodeID and ae.ActionTypeID=25) > AddMonth( -1, GetDate() )

) P

Where Created is not null

Order by Created desc

mesverrum

The official solution to this problem is just to build scheduled discoveries of your server subnets and have it automatically adding in all volumes that it finds. This also helps a bit with the problem of making changes to a volume in vcenter and having it get assigned a new serial number and the old volume shows as down in Orion.

jfaldmo

Thanks, guys, for the tips. This is the swql I came up with. But I'll look into the automatic discoveries.

SELECT TOP 1000 N.NodeID, N.Caption, COUNT(V.VolumeID) as CountOfVolume
FROM Orion.Nodes as N
LEFT JOIN Orion.Volumes as V ON N.NodeID = V.NodeID
WHERE N.ObjectSubType='Agent'
GROUP By N.NodeID, N.Caption
ORDER BY CountOfVolume