wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery public RSS

Dynamic Group

Devices with a Specific Monitor Down

Dynamic Group posted Feb 02 by Christian Lawson

79 Views

Name:

Devices with a Specific Monitor Down

Description:

A dynamic group that shows all devices who have a particular monitor assigned and that monitor is in a non-responding state. Replace the monitor name in between the % symbols to choose a different monitor. Be sure to leave the % symbols.

Language:

SQL

Code:

SELECT DISTINCT Device.nDeviceID   
 FROM Device   
     JOIN PivotActiveMonitorTypeToDevice ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID   
     JOIN ActiveMonitorType ON ActiveMonitorType.nActiveMonitorTypeID = PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID
     JOIN MonitorState ON PivotActiveMonitorTypeToDevice.nMonitorStateID = MonitorState.nMonitorStateID
 WHERE Device.bRemoved = 0 
     AND PivotActiveMonitorTypeToDevice.bRemoved = 0
     AND PivotActiveMonitorTypeToDevice.bDisabled = 0
     AND MonitorState.nInternalMonitorState = 1
     AND ActiveMonitorType.sMonitorTypeName LIKE '%Ping%'

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