IP Customization with CSV File

SkyC · ‎07-15-2009

Following the admin guide to create the csv file to hold the IP changes for the site. The issue I'm getting is that when it attempts to customize the IP, there is an issue in the log file with a select statement saying there is no adapter with the MAC address specified in the CSV file.

I validated the MAC address in both the VIC as well as in the OS where the error was seen. Is the format 00-00-00.... as shown in the example starting around page 54 of the admin guide, or something else? Assuming it isn't case sensitive as the select statement is running in the windows OS, please correct me if I'm wrong.

Michelle_Laveri · ‎07-16-2009

I've not used the CSV file. But imagine the "sample" is just dummy syntax...

You can find out the mac address of your VMs from editing the settings of the VM, clicking the network adapter...

MAC address of VMs are normally auto-assigned...

with just ESX - Begins with: 00:0C:29

with vCenter – Begins with: 00:50:56

This little bit of powershell should give you a list of the VMs and their mac addresses:

Get-VM | select name, @{Name="MAC"; expression={foreach($nic in (Get-View $_.ID).guest.net) {$nic.macAddress}}}

Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

Author of the SRM Book: http://www.lulu.com/content/4343147

Regards
Michelle Laverick
@m_laverick
http://www.michellelaverick.com

SkyC · ‎07-16-2009

Sorry if I wasn't clear in my original post,

I've validated the MAC address from looking at the properties within VIC of the VM as well as from the command line within the VM itself - which matched the MAC address that was found in the guest customization log, which had a select statement (looks like WMI) trying to find adapters with a matching MAC but no matches found.

The example I was mentioning with the 00-00 was just for the format, as the example in the admin guide uses dashes, but I was curious if I actually needed to use a : between instead. I will try again today with some different formats, but was just hoping someone who has used the tool could provide some input.

Michelle_Laveri · ‎07-16-2009

Ah. Misunderstood your question. Sorry!