topic Re: Get List of VMs, Datastores and VMDK / path per Cluster in VMware PowerCLI Discussions

Get List of VMs, Datastores and VMDK / path per Cluster

markus81 — Thu, 12 Jan 2012 09:55:26 GMT

Hi Folks,

as I´m new to this stuff, I´m wondering if anybody has already done some scripting work to gather a list of all virtual machines, its corresponding datastore(s) and the path to the VMDK-Files (or at least the name of it) - I know this part is already solved - found a couple of them

But my problem is, I need this script drilled down per Cluster or Datacenter. As I said I´m completly new to this CLI-Stuff and don´t have a clue about how to solve this..

Cheers

Markus

Re: Get List of VMs, Datastores and VMDK / path per Cluster

RvdNieuwendijk — Thu, 12 Jan 2012 10:38:52 GMT

Hi Markus,

Welcome to the VMware Communities!

The next PowerCLI script will give you a list of all your VM's and their Datacenter, Cluster, HardDisks, Datastores and VMDK file paths. If you want to have the VM's only for a certain datacenter or cluster, you can filter the output by piping it to the Where-Object cmdlet.

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="Datacenter";E={$Datacenter.name}},
          @{N="Cluster";E={$Cluster.Name}},
          @{N="Hard Disk";E={$HardDisk.Name}},
          @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
          @{N="VMDKpath";E={$HardDisk.FileName}}
      }
    }
  }
}

Don't hesitate to ask in this forum if you need more help.

Regards, Robert

Re: Get List of VMs, Datastores and VMDK / path per Cluster

markus81 — Thu, 12 Jan 2012 10:59:13 GMT

Hi Robert,

many thanks! That´s exactly what I´m looking for I think. I´m only struggling with one last thing... the Export-CSV-Thing... My understanding would be someting like

$myVariable | Export-CSV blablabla..

But how would i define the $myVariable in your script?

I´m sorry for those really stupid rookie-questions ... have to talk to my boss that I need time and lessons to learn this stuff

Thanks,

Markus

Re: Get List of VMs, Datastores and VMDK / path per Cluster

RvdNieuwendijk — Thu, 12 Jan 2012 11:57:30 GMT

There are two options if you want to write the output of the script to a .csv file. You can change the last line of the script into:

} | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

This will pipe the output of the script to the Export-CSV cmdlet. And it will create a .csv file called VmInfo.csv.

The second option is to change the first line of the script into:

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

And append the following line at the end of the script:

$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

This will put the output of the script from my previous post into a variable $VmInfo. In the last line the variable is used to output it to a .csv file.

Re: Get List of VMs, Datastores and VMDK / path per Cluster

LucD — Thu, 12 Jan 2012 12:00:15 GMT

Isn't option 1 giving you the infamous "An empty pipe element is not allowed." error ?

Re: Get List of VMs, Datastores and VMDK / path per Cluster

RvdNieuwendijk — Thu, 12 Jan 2012 12:14:50 GMT

Luc, you are right. I should have tested this.

This is a disadvantage of the ForEach command that I almost never use. Normally I use the Foreach-Object cmdlet and that works fine with pipeing the output to Export-CSV.

Markus you have to use option 2 in this case.

Re: Get List of VMs, Datastores and VMDK / path per Cluster

markus81 — Thu, 12 Jan 2012 12:43:59 GMT

You guys are crazy

Exactly what I need Many thanks to you ! Have just tested and works fine! If I find some spare time I´m trying to modify it a little bit more for more granularity in regards of choosing the cluster manually but for now that works perfect

Cheers
Markus

Re: Get List of VMs, Datastores and VMDK / path per Cluster

markus81 — Thu, 12 Jan 2012 14:03:40 GMT

Shame on me... Forgot one more thing .... Configuratio File of the VM...

Can anyone give a hint how to include this also?

Re: Get List of VMs, Datastores and VMDK / path per Cluster

RvdNieuwendijk — Thu, 12 Jan 2012 14:09:57 GMT

You can add the VM's configuration file to the script by changing the script into:

$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="Datacenter";E={$Datacenter.name}},
          @{N="Cluster";E={$Cluster.Name}},
          @{N="Hard Disk";E={$HardDisk.Name}},
          @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
          @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},
          @{N="VMDKpath";E={$HardDisk.FileName}}
      }
    }
  }
}
$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

Re: Get List of VMs, Datastores and VMDK / path per Cluster

GlennL10 — Tue, 06 Mar 2012 21:29:40 GMT

Hi guys,

Great script, works well, but I was wondering if it's possible to get the size of the VMDK file added to the output as well? How would I do this?

Re: Get List of VMs, Datastores and VMDK / path per Cluster

CRad14 — Wed, 07 Mar 2012 16:06:01 GMT

I will just add one line to this

$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="Datacenter";E={$Datacenter.name}},
          @{N="Cluster";E={$Cluster.Name}},
          @{N="Hard Disk";E={$HardDisk.Name}},
          @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
          @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},
          @{N="VMDKpath";E={$HardDisk.FileName}},
          @{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}
      }
    }
  }
}
$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

Message was edited by: CRad14

Re: Get List of VMs, Datastores and VMDK / path per Cluster

GlennL10 — Wed, 07 Mar 2012 20:44:09 GMT

Thanks for the reply, but I don't get the sizes in the final report, in fact it's still the same?

Re: Get List of VMs, Datastores and VMDK / path per Cluster

CRad14 — Wed, 07 Mar 2012 20:45:54 GMT

Hah!!! I missed a comma, I edited that post, it should be correct now.

Re: Get List of VMs, Datastores and VMDK / path per Cluster

GlennL10 — Wed, 07 Mar 2012 20:58:06 GMT

Thanks for your help, it works!

Re: Get List of VMs, Datastores and VMDK / path per Cluster

alize77 — Fri, 08 Jun 2012 05:51:06 GMT

Is there a way to capture multiple IP address of those VMs as well? Tried to include some of the scripts I got online to merge with this one but just couldn't get it to work correctly. Currently, I only manage to capture 1 IP address.

$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 ($IP in $VM.Guest.IPAddress) {

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

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

@{N="Datacenter";E={$Datacenter.name}},

@{N="Cluster";E={$Cluster.Name}},

@{N="IP";E={$IP}},

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

@{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},

@{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},

@{N="VMDKpath";E={$HardDisk.FileName}},

@{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}

}

$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

Re: Get List of VMs, Datastores and VMDK / path per Cluster

LucD — Fri, 08 Jun 2012 05:59:18 GMT

The IPAddress property is an array, you can always join the elements of this array into 1 string.

But note that you will get these same IP addresses (VM-level) displayed for each harddisk attached to that VM.

Something like this

$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="Datacenter";E={$Datacenter.name}},
        @{N="Cluster";E={$Cluster.Name}},
        @{N="IP";E={[string]::Join(',',$VM.Guest.IPAddress)}},
        @{N="Hard Disk";E={$HardDisk.Name}},
        @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
        @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},
        @{N="VMDKpath";E={$HardDisk.FileName}},
        @{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}
      }
    }
  }
}
$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "VmInfo.csv"

Re: Get List of VMs, Datastores and VMDK / path per Cluster

zerotraction — Tue, 12 Jun 2012 16:57:08 GMT

Hi - coming a little late to the party, but I believe this is the script that I'm looking for.

I'm pretty new to scripting for PowerCLI and having issues getting this working on our infrastructure. Getting an "Unexpected token '<' in expression or statement" error at line 10, character 72. Seems that it doesn't like the closed square bracket.

We're running version 4.1 and I'm using PowerCLI 4.1 as well.

Any ideas?

Thanks,

--- A

Re: Get List of VMs, Datastores and VMDK / path per Cluster

LucD — Tue, 12 Jun 2012 17:03:18 GMT

If you do not have a good reason to stick with PowerCLI 4.1, I would in any case advise an upgrade.

Let's first check if the copy/paste didn't introduce an error.

Try the attached script.

And copy the complete error message, should it still appear.

Re: Get List of VMs, Datastores and VMDK / path per Cluster

zerotraction — Tue, 12 Jun 2012 17:11:36 GMT

Thanks for the help -

When running the attached script, I get another error "Export-CSV : Cannot bind argument to parameter 'InputObject' because it is null." at Line 18, Character 21 (which is the - in -NoTypeInformation, etc.) in the last line.

Taking your advice to upgrade to PowerCLI 5.0.1 and hoping that that makes this issue go away.

Thanks again,

--- A

Re: Get List of VMs, Datastores and VMDK / path per Cluster

LucD — Tue, 12 Jun 2012 17:21:14 GMT

That would mean that the variable $VmInfo is empty ?

Try displaying the result on screen, remove the Export-Csv cmdlet at the end.