wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery public RSS

Dynamic Group

All devices with 3 attributes by attribute name and value

Dynamic Group posted 07/23/09 by Zachary Loeber

474 Views

Name:

All devices with 3 attributes by attribute name and value

Description:

Just like with 2 addtributes only more complex. So you could use this to find a server with the following attributes and values:

Contact=Server Admin

Patch Day=Wednesday

Location=Somewhere cold

Language:

SQL

Code:

SELECT DISTINCT db1.nDeviceID FROM DeviceAttribute db1 INNER JOIN DeviceAttribute db2 ON db1.nDeviceID = db2.nDeviceID INNER JOIN DeviceAttribute db3 ON db1.nDeviceID = db3.nDeviceID WHERE (db1.sName = 'Attribute1 Name' and db1.sValue = 'Attribute1 Value')    and    (db2.sName = 'Attribute2 Name' and db2.sValue = 'Attribute2 Value')    and    (db3.sName = 'Attribute3 Name' and db3.sValue = 'Attribute3 Value')

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