How to find devices on SolarWinds where CPU, Memory and Interfaces are not added

surnaihai899

Hello All

Is there a way we can pull a list of devices on SolarWinds where CPU, Memory and Interfaces are not added?

Devices discovered with SNMP but resources are not added. Can we do it through a SWQL/SQL query?

Lofstrand

Try this one:

SELECT
    N.Caption
    ,N.ObjectSubType AS PollingMethod
    ,Count(P_CPU.PollerID) AS CPU_Pollers
    ,Count(P_Mem.PollerID) AS MEM_Pollers
    ,ISNULL(I2.qty,0) AS Interfaces

FROM Orion.Nodes AS N
LEFT OUTER JOIN Orion.Pollers AS P_CPU ON N.nodeid=P_CPU.NetObjectID AND P_CPU.NetObjectType='N' AND P_CPU.PollerType LIKE '%CPU%'
LEFT OUTER JOIN Orion.Pollers AS P_MEM ON N.nodeid=P_MEM.NetObjectID AND P_MEM.NetObjectType='N' AND P_MEM.PollerType LIKE 'N.Memory.%'
LEFT OUTER JOIN 
(
    SELECT
        I.NodeID
        ,Count(I.interfaceID) as QTY
    FROM Orion.NPM.Interfaces AS I
    GROUP BY I.nodeid) AS I2 ON N.nodeid=I2.NodeID
WHERE
    N.ObjectSubType!='ICMP'
GROUP BY
    N.Caption,N.ObjectSubType,i2.qty

Should give you "0" where there are nothing monitored.