Change Display Name to Host Name

The script will change the display name of the device to be the same as its host name.

• Display name is populated during discovery, but can be changed by the user at any time.
• Host name is the DNS name that can be resolved to IP address.

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'