DB Table Connection Between Volumes Table VolumeID and Thresholds Table ID

Mike_Lomax

I am trying to find all Volumes in my environment that are using custom, not default, thresholds.  I am not finding the connection between 'VolumeID' in the Volumes table and either 'ID' or 'InstanceId' in the Thresholds table.  Can someone describe for me what table I need in order to find this connection?

Alternatively, do you have a query (SQL or SWQL) that either lists volumes with custom thresholds or all volumes showing default thresholds or custom thresholds as assigned.

Your help is greatly appreciated.

THANKS

Mike

Mike_Lomax

OK...  I did figure this out and will provide the answer here for anyone else looking.

The Thresholds table 'InstanceId' contains the Volumes table 'VolumeID'.  I was just reading things wrong here.  Great news as this makes my query easy to create.

Here is a basic SQL query that only collects the threshold values and not the operators, poll counts for baseline details:

SELECT T.InstanceId
	,N.Caption AS [Node Name]
	,V.Caption AS [Volume Label]
	,T.Level1Value AS [Warning Threshold]
	,T.Level2Value AS [Critical Threshold]
FROM Orion.Thresholds T
JOIN Orion.Volumes V ON V.VolumeID = T.InstanceId
JOIN Orion.Nodes N ON N.NodeID = V.NodeID
WHERE T.Level1Value IS NOT NULL OR T.Level2Value IS NOT NULL

I'll let you guys modify to add other details you might want.

Mike