wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery public RSS

Dynamic Group

Devices with ASPM assigned

Dynamic Group posted 11/20/09 by Christian Lawson

170 Views

Name:

Devices with ASPM assigned

Description:

This dynamic group displays all devices that have an Active Script Performance Monitor enabled in the device's Device Properties dialog.

Language:

SQL

Code:

SELECT DISTINCT Device.nDeviceID   
FROM Device   
    JOIN PivotStatisticalMonitorTypeToDevice ON Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID   
    JOIN StatisticalMonitorType ON StatisticalMonitorType.nStatisticalMonitorTypeID = PivotStatisticalMonitorTypeToDevice.nStatisticalMonitorTypeID   
    WHERE  Device.bRemoved = 0   
        AND PivotStatisticalMonitorTypeToDevice.bEnabled = 1   
        AND StatisticalMonitorType.nCLSID = '07D98585-8694-4882-BDDF-4C826B3A8788'

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