Find VMs (and info) from a MAC address txt file

[vmCalgary]

I'm looking for a way where I can import (get-content) a txt file or a csv that lists mac addresses. The user doesn't know his VM names but does know his mac addresses. I'd like to report back to him the following information in an exported csv file.

VM Name

Guest IP address [0]

VM ID

Cluster Name

Mac Address

vCenter Name

Sample Data from the txt:

00:50:56:b8:a4:9a

00:50:56:92:36:d6

00:50:56:b8:61:cc

00:50:56:b8:e6:92

00:50:56:b8:4f:32

00:50:56:b8:b5:f0

00:50:56:b8:f4:cf

00:50:56:b8:b0:c7

[LucD]

Try something like this

$macTab = @{}

Get-VM -PipelineVariable vm | Get-NetworkAdapter |

   ForEach-Object -Process {

   $macTab.Add($_.MacAddress, $vm)

}

Get-Content -Path .\mac.txt |

   ForEach-Object -Process {

   $vm = $macTab[$_]

   $_ | Select @{N = 'VM'; E = {$vm.Name}},

   @{N = 'IP'; E = {$vm.Guest.IPAddress[0]}},

   @{N = 'Id'; E = {$vm.Id}},

   @{N = 'Cluster'; E = {(Get-Cluster -VM $vm).Name}},

   @{N = 'Mac'; E = {$_}},

   @{N = 'vCenter'; E = {([uri]$vm.ExtensionData.Client.ServiceUrl).Host}}

}

[vmCalgary]

Hi Luc,

That worked like a charm. Thank you. Just an FYI I did get the following but still got the information asked for. This worked perfectly for identifying the VMs and which vcenter they are on. I connected to a production and lab vcenters. Thank you once again.

Exception calling "Add" with "2" argument(s): "Item has already been added. Key in dictionary: '00:50:56:84:5c:db'

Key being added: '00:50:56:84:5c:db'"

At line:6 char:4

+    $macTab.Add($_.MacAddress, $vm)

+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException

    + FullyQualifiedErrorId : ArgumentException

Results:

      

VM	IP	Id	Cluster	Mac	vCenter
app334.so.cg.nms.mlb.inet	10.187.215.74	VirtualMachine-vm-4976	PROD-CG-SO-MLB	00:50:56:8B:57:32	vc008no
app093cv.cv.gv.int.net	10.187.215.164	VirtualMachine-vm-4809	PROD-GV-CV-CCA-MLB	00:50:56:89:5A:E8	vc008no
mn29.st.vc.nms.mlb.inet	10.187.215.40	VirtualMachine-vm-9625	PROD-VC-ST-MLB	00:50:56:B8:3F:01	vc008no
app152ht.ht.ok.int..net	10.187.215.196	VirtualMachine-vm-4821	PROD-OK-HT-CCA-MLB	00:50:56:8B:1D:37	vc008no
app094nr.nr.wp.int.net	10.187.215.132	VirtualMachine-vm-1167	PRD-WP-NR-MLB	00:50:56:89:1D:35	vc008no
app095nr.nr.wp.int.net	10.187.215.134	VirtualMachine-vm-9540	PRD-WP-NR-MLB	00:50:56:B8:03:17	vc008no

[LucD]

It looks like you might have the same MAC twice in that list.