how to add a domain name contoso.com to a hostname

September 21, 2015 at 07:48:51
Specs: Windows 7, 4gb
I have CSV file containing multiple columns and one of it is hostnames. How can we change all the hostnames and include the domain name to it for example the hostname xyz should become xyz.contoso.com. This should be automated every time i drop a file with the multiple hosntnames in the path.
thanks in advance.

Regards,
Shiv


See More: how to add a domain name contoso.com to a hostname

Report •


#1
September 21, 2015 at 11:37:28
Do you want to actually change the hostname on existing computers? Or just edit the CSV file to add the domain name to the hostname?

Report •

#2
September 21, 2015 at 20:49:11
@beach: no. Just the csv file. Which would be fairly simple. But I don't do "drag and drop" since the last time I tried to help to use D&D method (someone else, not this poster) I got flamed as a dumb-ass(admitedely, I know "beans" about "drag and drop" and anyway I don't care.).

message edited by nbrane


Report •

#3
September 22, 2015 at 04:48:01
Well... :) Can you open the file in Excel? Or a text editor? Either way, I think simplest is best. Copy .contoso.com and paste it to the end of each hostname. Depending on how many entries you have...and what you're using to edit the file.

In Excel, there's an option to use & to add content to a cell. Again, not knowing what program you're using...

My VBA skills are non-existent, but I'm sure someone here could give you the code to append each entry.

message edited by beachyhbt


Report •

Related Solutions


Ask Question