topic Re: datatore VM report in VMware PowerCLI Discussions

datatore VM report

tdubb123 — Fri, 24 Feb 2017 17:14:14 GMT

how can I get a report on what vms are on what datastores ?

I have this working but the format is not what I am looking for

Get-Content .\luns.txt | % { Get-vm -Datastore $_ | select name, @{N="Datastore";E={[string]::Join(',',(get-datastore -id $_.datastoreIdlist | select -ExpandProperty Name))}}} | Export-Csv vms_in_datastore_report.csv

I want to have the output like

datastorename1 VM1

VM2

datastorename2 VM3

VM4

Re: datatore VM report

LucD — Fri, 24 Feb 2017 19:03:00 GMT

Try like this

$dsNames = Get-Content .\luns.txt

Get-Datastore -Name $dsNames | %{

$obj = [ordered]@{

Datastore = $_.Name

VM = ''

}

$i = 1

(Get-View -Id $_.ExtensionData.VM -property Name).Name | %{

If($i -gt 1){

$obj.Datastore = ''

}

$obj.VM = $_

$i++

New-Object PSObject -Property $obj

}

} | Export-Csv D:\Temp\report.csv -NoTypeInformation -UseCulture

Re: datatore VM report

tdubb123 — Fri, 24 Feb 2017 21:25:15 GMT

Thanks luc

is this another way to get my VM to datastore info?

foreach ($ds in (get-content luns.txt){

get-vm -datastore $ds | select Name, @{N="datastore"; e=$ds}}

Re: datatore VM report

LucD — Fri, 24 Feb 2017 22:41:18 GMT

That will work as well (there is always more than one way to achieve something in PowerShell).

I used the Get-View construct, since that tends to be a bit faster in larger environments.

Re: datatore VM report

tdubb123 — Mon, 27 Feb 2017 19:56:41 GMT

hi Luc

how come I dont get the results I want with this ?

get-datastore | get-vm | select Name, @{N="datastore"; e={$_ | get-view).config.datastoreurl}}

Re: datatore VM report

LucD — Mon, 27 Feb 2017 20:21:17 GMT

There are a couple of "issues".

there is a parenthesis missing at the start of the Expression code block
The DatastoreUrl property points to a VirtualMachineConfigInfoDatastoreUrlPair object, which has multiple properties. If you don't select the property, the Select-Object don't know how to display the values
A VM can have multiple datastores. To cope with that (especially when you to do an Export-Csv or similar), join the values together into one string

Try like this

Get-Datastore | Get-VM |

select Name, @{N="datastore"; e={($_ | get-view).config.datastoreurl.Name -join ' | '}}

Re: datatore VM report

tdubb123 — Mon, 27 Feb 2017 21:24:35 GMT

yes makes sense. thanks

Re: datatore VM report

tdubb123 — Tue, 28 Feb 2017 21:48:40 GMT

hi lucd

playing around with this varation

$result = @()

$luns = get-content luns.txt

foreach ($lun in $luns) {

$vms = get-vm -datastore $lun

foreach ($vm in $vms) {

$datastore = get-vm $vm | Get-Datastore

$obj = New-Object psobject

$obj | add-member -MemberType NoteProperty -Name VM_NAme -Value $vm.Name

$obj | Add-Member -MemberType NoteProperty -Name Datastore_NAme -Value $datastore.Name

$result += $obj

}

$result | ft -AutoSize

Can i use a single foreach loop to get this to work?

Re: datatore VM report

LucD — Wed, 01 Mar 2017 05:47:38 GMT

This is another way of doing the same.

Get-Datastore -Name (Get-Content luns.txt) -PipelineVariable ds |

Get-View -Id $ds.ExtensionData.VM -Property Name |

Select @{N='Datastore';E={$ds.Name}},

@{N='VM';E={$_.Name}}

} | ft -AutoSize