How to Auto-Update device names after name change at device.

FormerMember

USE AT YOUR OWN RISK

I did this in the most current version of NPM

Update Nodes

Set Caption = ''

[Optional Criteria]

All nodes will update to the current Sysname

Find more posts tagged with

network_monitoring

network_management

Accepted answers

All comments

ptrog

where do i put this?

sean.martinez

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 <>''