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, 

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