wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery public RSS

Dynamic Group

Devices with a monitor assigned but no credentials

Dynamic Group posted 11/10/09 by Christian Lawson

222 Views

Name:

Devices with a monitor assigned but no credentials

Description:

Identifies all devices that have a particular SNMP-based Active Monitor assigned, but are missing the required SNMP credentials. You'll need to change the %SNMP% variable to match the name of your monitor.

Language:

SQL

Code:

SELECT DISTINCT Device.nDeviceID
FROM Device 
JOIN PivotActiveMonitorTypeToDevice ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID
JOIN ActiveMonitorType ON ActiveMonitorType.nActiveMonitorTypeID = PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID   
WHERE Device.bRemoved = 0
    AND PivotActiveMonitorTypeToDevice.bRemoved = 0
    AND ActiveMonitorType.sMonitorTypeName LIKE '%SNMP%'
    AND Device.nDeviceID NOT IN 
        (
            SELECT DISTINCT nDeviceID 
                FROM PivotCredentialTypeToDevice 
                JOIN CredentialType ON CredentialType.nCredentialTypeID = PivotCredentialTypeToDevice.nCredentialTypeID 
                WHERE nCredentialType IN (1, 2, 4)
        )

Disclaimer:

All scripts found on wugSpace are provided as-is with no warranty or guarantee. These scripts are not supported by Ipswitch Technical Support. If you have a problem with this script, please ask any questions in the comments.

Be the first to rate this
|
Sign in to rate this