Is there any report that can provide details of all thresholds and parameters configured

Question

Hi All,

Need help on reporting front.

Is there any report that can provide details of all thresholds and parameters configured for the devices in monitoring.. We are requested to make this report available for every customer so rather than doing it manual, i was thinking if one report can be  built to serve this need.

pratikmehta003 · Answer

Thanks a lot... Let me try this query and will revert back..

i_like_eggs · Answer

You could consider using something like this with a custom query widget, you could tweak to not use the (n.nodeID = ${NodeID}) to get all records, with further tweaking you can create the same for interfaces. this wont cover all thresholds but gives you a starting point for sure..

SELECT tn.DisplayName as  Object

,Concat(CurrentValue,+' '+tn.Unit) as Currently

,t.level1value AS Warning

,t.level2value AS Cricital

--, n.NodeName

FROM Orion.Thresholds t

INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId

INNER JOIN Orion.ThresholdsNames tn on tn.Name = t.Name

WHERE t.EntityType = 'Orion.Nodes' AND (n.nodeID = ${NodeID})