

Orchtech is a software development company working in multiple countries worldwide and our experience spans over multiple services/products such as Offshoring/Outsourcing software development, Mobile applications development services, Web development and HR mobile applications for internal employees management.
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'
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.