Powershell Script to pull records with VM-Name,LUN-Name and Vmdk file name and its path.

This script will export following information into a .csv file:

1) name of the virtual machine (VM)
2) datacenter name
3) cluster name
4) hard disc
5)datastore name
6) path and name of the .vmdk file

Note: Change vCenter Server name to your vCenter Server Name

Connect-VIServer  vCenter_server_name

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) {

ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) {

ForEach ($VM in ($Cluster | Get-VM | Sort-Object -Property Name)) {

ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) {

“” | Select-Object -Property @{N=”VM”;E={$VM.Name}},



@{N=”Hard Disk”;E={$HardDisk.Name}},







$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path “C:\VmQuery.csv”


About Manish Jha

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.
This entry was posted in PowerShell Scripts, Vmware. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s