wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery publicRSS

Dynamic Group

Devices with no actions assigned

Dynamic Group posted 6/26/09 by Kerry Myers1568, last edited 7/28/09 by Will Sansbury

1865 Views

Name:

Devices with no actions assigned

Description:

Used to identify devices which have no actions assigned to the device or any of the active monitors on that device.

Language:

SQL

Code:

SELECT  Device.nDeviceID
FROM Device   
LEFT OUTER JOIN ActionPolicy   
ON Device.nActionPolicyID = ActionPolicy.nActionPolicyID   
LEFT OUTER JOIN PivotActiveMonitorTypeToDevice   
ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID   
LEFT OUTER JOIN ActionPolicy AP
ON PivotActiveMonitorTypeToDevice.nActionPolicyID =   
AP.nActionPolicyID
WHERE Device.bRemoved = 0   
AND ActionPolicy.sPolicyName IS NULL
GROUP BY Device.nDeviceID
Having MAX(AP.sPolicyName) IS NULL

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.

Average Rating: 3 ratings
|
Sign in to rate this