This is what is what was sent to me. Since Im not a SQWL guy, I don't think that I have this set up correctly. This is to create a hurricane report showing the number of operations cable modems and their corresponding NODE and interface name with in the Arris E6000. NEED SOME HELP!!!!!
SELECT Nodes.Caption AS E6000,
Interfaces.Alias AS cable-mac,
PollerData.Value as [Number of Operational Cable Modems}
FROM Nodes JOIN Interfaces on Interface.NodeID = Nodes.NodeID JOIN PollerData ON PollerData.NodeID = Nodes.NodeID
AND PollerData.InterfaceID = Interfaces.InterfacesID
AND PollerData.OID = '1.3.6.1.4.1.4998.1.1.105.1.1.1.1.23'
WHERE PollerData.Value IS NOT NULL
