Mike Rockwell (Progress Software) asked a question.
Devices missing SNMP OID
This was originally posted by John Abrams, then updated by Nestor Vives and then by me.
This query will display all devices which are missing the SNMP OID but are SNMP enabled.
- SELECT DISTINCT nDeviceID
- FROM Device
- WHERE (bRemoved = 0) AND (bSnmpManageable = 1) AND (ISNULL(sSnmpOID, N'') = '')
This one also has if the device also has an SNMP credential applied but no SNMP OID
- SELECT DISTINCT Device.nDeviceID
- FROM Device LEFT OUTER JOIN
- PivotCredentialTypeToDevice ON PivotCredentialTypeToDevice.nDeviceID = Device.nDeviceID LEFT OUTER JOIN
- CredentialType ON CredentialType.nCredentialTypeID = PivotCredentialTypeToDevice.nCredentialTypeID
- WHERE (Device.bRemoved = 0) AND (Device.bSnmpManageable = 1) AND (CredentialType.nCredentialType IN (1, 2, 4)) AND (ISNULL(Device.sSnmpOID, N'') = '')