2 Replies Latest reply on May 15, 2014 10:23 AM by sean.martinez

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

    pyro13g

      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

          • Re: How to Auto-Update device names after name change at device.
            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 <>''