Hi, looking for assistance please with a SWQL to show availability of a specific node or application availability as a KPI widget.
Thanks
Hi there,
I have discussed something very similar in the past in this thread: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/92418/need-help-in-kpi-swql-query
Please have a read through and look at my queries to see if anything is going to be of help to you.
Kind regards,
Marlie Fancourt | SolarWinds Pre-Sales Manager
Prosperon Networks | SolarWinds Partner since 2006
If this helps answer your question please mark my answer as confirmed to help other users, thank you!
Hi, anyone managed to do this?
Thanks @marlief22
That helps, have managed to edit for Last24 hours availability on a specific Node
SELECT round (AVG(Availability),2) AS AVGAvailability, NodeID FROM Orion.ResponseTimeWhere DateTime >= AddHour(-24, GETDATE()) AND NodeID IN (SELECT NodeID from Orion.Nodes WHERE NodeName = 'Server1')GROUP BY NodeID
Would it be possible to do the same for a Group or Application?
