Change Polling Type

In DHCP network, there is a problem of changing IPs and we need WUG to continue monitoring the devices without any problem so we need to change the polling type to use DNS Name instead of IP Address.

bPollUsingNetworkName = 1 (Poll using DNS Name)
bPollUsingNetworkName = 0 (Poll using IP Address) 

To update the polling type for all devices, use the following query

UPDATE NetworkInterface
SET bPollUsingNetworkName = 1

To update the polling type for range of addresses, use the following query

UPDATE NetworkInterface
SET bPollUsingNetworkName = 1
WHERE sNetworkAddress BETWEEN '192.168.1.100' AND '192.168.1.110'

To update the polling type for devices using part of their names, use the following query

UPDATE NetworkInterface
SET bPollUsingNetworkName = 1
WHERE sNetworkName LIKE 'ot-%'

To update the polling type for certain device group, use the following query

UPDATE NetworkInterface
SET bPollUsingNetworkName = 1
WHERE nDeviceID in (
SELECT PDG.nDeviceID AS DeviceID
FROM PivotDeviceToGroup AS PDG
LEFT OUTER JOIN Device ON Device.nDeviceID = PDG.nDeviceID
LEFT OUTER JOIN DeviceGroup ON DeviceGroup.nDeviceGroupID = PDG.nDeviceGroupID
WHERE sGroupName = 'Orchtech')