Universal Device Poller data on Modern Dashboard

Here's an example:

SELECT O.Status / 10 AS Temperature
FROM Orion.Nodes AS n
LEFT JOIN Orion.NPM.CustomPollerStatusOnNode S ON n.NodeID = S.NodeID
LEFT JOIN Orion.NPM.CustomPollerStatus O ON S.CustomPollerAssignmentID = O.CustomPollerAssignmentID
WHERE (S.CustomPollerID = 'Enter Custom Poller ID') AND (n.Caption = 'Enter Node Name')


To retrieve the Custom Poller ID run the following using the Hand-edit a SWQL query:

SELECT GroupName,
CustomPollerID,
FROM Orion.NPM.CustomPollers
WHERE GroupName LIKE 'Custom Poller Name'

I hope this helps!

Here's another example for active VPN users count:

SELECT CurrentValue

FROM Orion.NPM.CustomPollerAssignmentOnNode

Where NodeID = 'X' AND DisplayName LIKE 'XXXXXXX'

X = SolarWinds Node ID

XXXXXXX = Name of the poller. It is usually something like crasNumSessions

Hope this helps.

Say you're monitoring two different ASAs for VPN sessions and you wanted one number displayed for the total number of active connections between both devices, how would you write that SWQL query? I've looked at a lot of SWQL articles but I can't find one that helps me understand how to better use the SUM aggregate function. I'm basically trying to combine these two queries into one:

SELECT CurrentValue
FROM Orion.NPM.CustomPollerAssignmentOnNode
Where NodeID Like '1276' AND DisplayName LIKE 'AnyConnectVPN_Sess'

SELECT CurrentValue
FROM Orion.NPM.CustomPollerAssignmentOnNode
Where NodeID Like '1271' AND DisplayName LIKE 'AnyConnectVPN_Sess'

below gives the total sessions from two devices. works for me in our environment.

SELECT
count ([data].[RemoteAccessSessions].[UserName]) AS [Number]
FROM orion.asa.node AS data
where [data].[RemoteAccessSessions].[SessionStatus] = 1
and ([data].[RemoteAccessSessions].[NodeId] = 123 or [data].[RemoteAccessSessions].[NodeId] = 456)
and [data].[RemoteAccessSessions].[DisconnectedTime] is null