VM's list running on the specific Hosts in a cluster

[vmk2014]

Hi All,

Can we pull the list of VM's running on specific host e.g. C:\temp\hostname.txt.  from power cli script ?

Want to include cluster name also and power state of VM's

thanks

vmk

[LucD]

Try something like this

Get-VMHost -Name (Get-Content -Path C:\temp\hostname.txt) -PipelineVariable esx |

Get-VM |

Select @{N='Cluster';E={(Get-Cluster -VMHost $esx).Name}},

   @{N='VMHost';E={$esx.Name}},

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

[vmk2014]

LucD,

Can we add the VM's state whether it's powered on off?

thanks

vmk

[LucD]

Sure

Get-VMHost -Name (Get-Content -Path C:\temp\hostname.txt) -PipelineVariable esx |

   Get-VM |

  Select @{N = 'Cluster'; E = {(Get-Cluster -VMHost $esx).Name}},

@{N = 'VMHost'; E = {$esx.Name}},

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

PowerState

[vmk2014]

LucD,

Sorry for the delayed reply.  I missed out sharing that the script unable to read hostname in  FQDN. Can you add that too?

[LucD]

Try like this

Get-VMHost -Name (Get-Content -Path C:\temp\hostname.txt) -PipelineVariable esx |

Get-VM |

Select @{N = 'Cluster'; E = {(Get-Cluster -VMHost $esx).Name}},

   @{N = 'VMHost'; E = {$esx.Name}},

   @{N = 'VMHost FQDN';E={"$($esx.NetworkInfo.HostName).$($esx.NetworkInfo.DomainName)"}},

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

  PowerState

[vmk2014]

LucD,

the output generated without any error but VM's state is not reflecting whether it's powered off or on

Cluster

VMHost

VMHost FQDN

VM

thanks

vmk

[LucD]

Is that your output header?

There is no PowerState property. Or is that because it doesn't fit on your screen? Try to pipe the output to Format-List.
Can you show me the code you are using? It looks like the last line from my code is missing.

[vmk2014]

Get-VMHost -Name (Get-Content -Path C:\temp\hostname.txt) -PipelineVariable esx |

Get-VM | Select @{N = 'Cluster'; E = {(Get-Cluster -VMHost $esx).Name}},

   @{N = 'VMHost'; E = {$esx.Name}},

   @{N = 'VMHost FQDN';E={"$($esx.NetworkInfo.HostName).$($esx.NetworkInfo.DomainName)"}},

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

Export-Csv -Path C:\Temp\VM-lists_runningonHost.csv -NoTypeInformation -UseCulture

[LucD]

You dropped the last line that contains PowerState

[vmk2014 · Accepted solution]

Oops you are right. Now, i can see the report without any flaw.

[LucD]

Was it the intention that you marked your own reply as the correct answer?