SWQL - 3 Custom pollers to display in a table

Hey Guys,

I have yet another one which I am a little stuck on.

I have 3 custom pollers;

  • snChasUnitActualTemperature
  • snChasUnitWarningTemperature
  • snChasUnitShutdownTemperature

These are Custom Pollers created to poll Brocade/Foundry switches for Temperature statistics. Current pollers I have set to Get-Next, rather than table.

I've also had to create Transform Results for each of these like below;

  • {snChasUnitActualTemperature}*0.5
  • {snChasUnitWarningTemperature}*0.5
  • {snChasUnitShutdownTemperature}*0.5

When i look at the backend SWQL for these above i get

  1. I like to understand how to get this data with the transform or without it but adding the (*0.5) to modify the value?
  2. I need to get a SWQL query created to display something in the below table format;

NodeName | IP Address | Current Temperature | Warning Temp | Shutdown Temp

Any help with this would be greatly appreciated.

Parents
  • Here is what i created thus far to display one of the custom pollers

    Select 
    Nodes.Caption
    , Status.Status
    
    From Orion.NPM.CustomPollerAssignment as Assignment
    , Orion.NPM.CustomPollerStatus as Status
    , Orion.NPM.CustomPollers
    , Orion.Nodes
    
    where Assignment.CustomPollerID = CustomPollers.CustomPollerID 
    and Assignment.CustomPollerAssignmentID = Status.CustomPollerAssignmentID 
    and Assignment.NodeID = Nodes.NodeID
    and Assignment.AssignmentName like 'snChasUnitAct%'

Reply
  • Here is what i created thus far to display one of the custom pollers

    Select 
    Nodes.Caption
    , Status.Status
    
    From Orion.NPM.CustomPollerAssignment as Assignment
    , Orion.NPM.CustomPollerStatus as Status
    , Orion.NPM.CustomPollers
    , Orion.Nodes
    
    where Assignment.CustomPollerID = CustomPollers.CustomPollerID 
    and Assignment.CustomPollerAssignmentID = Status.CustomPollerAssignmentID 
    and Assignment.NodeID = Nodes.NodeID
    and Assignment.AssignmentName like 'snChasUnitAct%'

Children
  • Hey , I think this may be of some help for you.

    Find the CustomPollerID's of those pollers using the 1st query below (not the CustomPollerAssignmentID's), and then update the 2nd query appropriately on lines 8, 9 and 10. The CustomPollerID of snChasUnitActualTemperature should go in line 8 for the first INNER JOIN, then so on with the others.

    Let us know if you have any questions or need more guidance on this, and hope it helps! Slight smile

    1st query:

    SELECT
         cp.UniqueName
        ,cp.Uri
        ,cp.CustomPollerID
        ,cp.MIB
        ,cp.OID
        ,cp.PollerType
        ,cp.SNMPGetType
    FROM Orion.NPM.CustomPollers AS cp
    -- WHERE cp.SNMPGetType = 'GetNext'

    2nd query:

    SELECT
         n.Caption
        ,n.IP_Address
        ,p1.Status AS [Actual Temp]
        ,p2.Status AS [Warning Temp]
        ,p3.Status AS [Shutdown Temp]
    FROM Orion.Nodes AS n
    INNER JOIN Orion.NPM.CustomPollerStatusOnNodeScalar AS p1 ON p1.CustomPollerID = '<CustomPollerID-#1>' AND n.NodeID = p1.NodeID
    INNER JOIN Orion.NPM.CustomPollerStatusOnNodeScalar AS p2 ON p2.CustomPollerID = '<CustomPollerID-#2>' AND n.NodeID = p2.NodeID
    INNER JOIN Orion.NPM.CustomPollerStatusOnNodeScalar AS p3 ON p3.CustomPollerID = '<CustomPollerID-#3' AND n.NodeID = p3.NodeID

    Depending on where you end up using this query (classic dashboard or modern dashboard)... additionally you could use a CASE statement to add in status icons based off what the actual temp poller reads and so on. Let us know and we could help out there.....

    Good luck and cheers!!