node name change

To test on a few nodes, add a where statement to the end of the script similar to what you see below.

As for the domain names, here is a good start. It will have to be customized a little to match your domain name(s). Simply add or delete the WHEN/THEN statements as needed. You will need a WHEN/THEN for each domain name you use.

UPDATE Nodes
  SET caption = (
SELECT RTRIM( SUBSTRING(
        sysName, 1,( (
            Select CASE
           WHEN (CharIndex ('.domain1.com', sysName) > 0)
              THEN (CharIndex ('.domain1.com', sysName)-1)
            WHEN (CharIndex ('.domain2.com', sysName) > 0)
              THEN (CharIndex ('.domain2.com', sysName)-1)
            WHEN (CharIndex ('.domain3.com', sysName) > 0)
              THEN (CharIndex ('.domain3.com', sysName)-1)
             ELSE (LEN(sysName))
            END ) )
            )
         )

) 
Where (IP_Address= 'xxx.xxx.xxx.xxx') AND (IP_Address= 'yyy.yyy.yyy.yyy')

--Replace domain#.com with your domain name.

--Replace xxx.xxx.xxx.xxx and yyy.yyy.yyy.yyy with your test node IPs.

To expand your test group, add more ips to the where statement in the format of" AND (IP_Address= 'yyy.yyy.yyy.yyy') "

You could also use any other field in the WHERE statement. Like city = 'Greenville' or location = 'closet 4' or what ever you like.

You dont have to worry as much about messing something up if you limit it with the WHERE statement.

Hope this helps. Feel free to ask more questions if they arise.

Thanks.  I am still holding off.  I was reading thru the SP4 release hoping it would be addressed, and still not.  I hate losing the data, but we are just rediscovering everything that we change.  I can't beleive something like this is not important enough to have made it to a service pack.  I'd much rather right click and select rediscover and have that kick off the sysname discovery, but I guess I'll wait for another SP or 2.