Page 1 of 1
Bulk modify host addresses
Posted: Mon Nov 10, 2014 9:46 am
by snapon_admin
I'm assuming this isn't something that's easily possible, but I figured I'd post here to check anyway. Does anyone know of a way to bulk modify the host address of a ton of hosts?
Re: Bulk modify host addresses
Posted: Mon Nov 10, 2014 10:10 am
by slansing
The way I'd do it, would be via the Bulk Host Cloning Wizard, I'd clone the hosts out to the new addresses, then just disable/remove the old ones. Since it's not currently a feature, that is one of the workarounds I've suggested.
Re: Bulk modify host addresses
Posted: Mon Nov 10, 2014 11:56 am
by snapon_admin
Hmm, good idea. Question on that. If I use the bulk host cloning wizard and clone a host with the same host name, what does that do to the original host? Will the new one overwrite the old? E.g. <host1><address1> clone to <host1><address2>. If the host name remains the same, would I still have 2 host config files or would that second host with the new address actually replace the config files of the original?
Re: Bulk modify host addresses
Posted: Mon Nov 10, 2014 12:00 pm
by BanditBBS
You could grab all the host cfg files, modify as needed, throw them in the import folder and use the import tool making sure to check the box "overwrite database"
Re: Bulk modify host addresses
Posted: Mon Nov 10, 2014 2:09 pm
by tmcdonald
Do you have a CSV or other file showing the relationship between the old IP and the new, or the hostname and the new address? If so you can do some direct SQL modifications, but we would want to test this first as modifying the db directly can be dangerous.