where do i put this?
You will need to execute this query into MS SQL to update the device information en masse.
These queries I have made to make a mass change to the Node Caption field to update what you see in the Web Console
--Update ICMP Nodes and change the Display name from the IP Address to the DNS Name where DNS is not empty
update Nodes set Caption=dns where objectsubtype='ICMP' AND DNS <>''
--Updates all Nodes and change display name to DNS Name. If DNS is blank, the entry will not be updated.
update Nodes set Caption=dns where DNS <>''
--In case DNS resolution is not available for the device name, this updates Nodes and setting the Caption equal to the SysName field if the DNS Entry is empty and SysName is not empty
update Nodes set Caption=SysName where DNS = '' and SysName <>''