Universal Device Poller data on Modern Dashboard

Hi, 

I've made some custom universal device pollers. I would like to publish some of the results as a KPI number on the modern dashboard.
I'm pretty sure that this should be possible with SWQL, but for some reason I'm not able to succeed. The universal device poller checks for the temperature on one device at the moment.

Can somebody provide a possible example on this? 

Thanks in advance, 

Parents
  • 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

Reply
  • 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

Children
No Data