2 Replies Latest reply on Sep 7, 2016 2:46 PM by sans

    Report for failing SNMP/ WMI polling

    Manilyn Ramos

      I have already tried to use the LastSystemUpTimePollUtc but, i got a false result. An example a node with NULL value, upon testing, the WMI credential was successful and able to gather data. I tried to run the Poll Now as well as the Discover Now but the LastSystemUpTimePollUtc of the said node was still empty.

       

      Would like to ask, do you guys any other technique with regard on this failing snmp/ wmi polling report?

       

      Thank you.

        • Re: Report for failing SNMP/ WMI polling
          amarnath_r

          Hello Manilyn,

           

          Create a new SQL Report

           

          For SNMP

           

          SELECT n.Caption,

          n.IP_Address,

          DATEDIFF(mi,MAX(c.DateTime),GETDATE()) minutes_since

          FROM Nodes n

          INNER JOIN CPULoad c ON n.NodeID = c.NodeID

          WHERE n.Status = 1 AND n.ObjectSubType LIKE 'SNMP'

          GROUP BY n.Caption, n.IP_Address

          HAVING DATEDIFF(mi,MAX(c.DateTime),GETDATE()) > 15

          ORDER BY minutes_since DESC

           

          For WMI

           

          SELECT n.Caption,

            n.IP_Address,

            DATEDIFF(mi,MAX(c.DateTime),GETDATE()) minutes_since

          FROM Nodes n

          INNER JOIN CPULoad c ON n.NodeID = c.NodeID

          WHERE n.Status = 1 AND n.ObjectSubType LIKE 'WMI'

          GROUP BY n.Caption, n.IP_Address

          HAVING DATEDIFF(mi,MAX(c.DateTime),GETDATE()) > 15

          ORDER BY minutes_since DESC

          3 of 3 people found this helpful