"WhatsUp Gold Network Ports"
"Create Customized Syslog Monitor"
The script will change the display name of the device to be the same as its host name.
UPDATE Device
SET Device.sDisplayName = NetworkInterface.sNetworkName
FROM Device
LEFT OUTER JOIN NetworkInterface ON
Device.nDefaultNetworkInterfaceID = NetworkInterface.nNetworkInterfaceID
Apply changes for specific group
UPDATE Device
SET Device.sDisplayName = NetworkInterface.sNetworkName
FROM Device
LEFT OUTER JOIN NetworkInterface ON
Device.nDefaultNetworkInterfaceID = NetworkInterface.nNetworkInterfaceID
LEFT OUTER JOIN PivotDeviceToGroup ON PivotDeviceToGroup.nDeviceID = Device.nDeviceID
LEFT OUTER JOIN DeviceGroup ON DeviceGroup.nDeviceGroupID = PivotDeviceToGroup.nDeviceGroupID
WHERE DeviceGroup.sGroupName = 'Test'
Apply changes for devices with certain Attribute
UPDATE Device
SET Device.sDisplayName = NetworkInterface.sNetworkName
FROM Device
LEFT OUTER JOIN NetworkInterface ON
Device.nDefaultNetworkInterfaceID = NetworkInterface.nNetworkInterfaceID
LEFT OUTER JOIN DeviceAttribute ON DeviceAttribute.nDeviceID = Device.nDeviceID
WHERE DeviceAttribute.sName = 'Location' AND DeviceAttribute.sValue = 'Data Center Room'