Get-TagAssignment | select -ExpandProperty Tag

[vmware-oebb]

Hi,

How can I get the Tags of VMhost?

This Script works.

Get-Cluster -Name MS-ONLY | Get-VM  | Select Name,

@{N="Tags VM";E={((Get-TagAssignment -Entity $_ | select -ExpandProperty Tag).Name -join ",")}},

@{N="Datastore";E={Get-Datastore -VM $_}},

@{N="Cluster";E={Get-Cluster -VM $_}},

@{N="ESX Host";E={Get-VMHost -VM $_}},

@{N="Tags Host";E={Get-VMhost -VM $_ | Get-TagAssignment | select -ExpandProperty Tag | Select Name}}

But the Output is:

Tags VM : STRETCHED-MS-ONLY,ARS,WIEN

Datastore : ARS_SVC_MS-ONLY_VOL_13

Cluster : MS-ONLY

ESX Host : as12128.org.oebb.at

Tags Host : {@{Name=ARS}, @{Name=STRETCHED-MS-ONLY}, @{Name=WIEN}}

The Output should be:

Tags VM : STRETCHED-MS-ONLY,ARS,WIEN

Datastore : ARS_SVC_MS-ONLY_VOL_13

Cluster : MS-ONLY

ESX Host : as12128.org.oebb.at

Tags Host : ARS,STRETCHED-MS-ONLY,WIEN

thank's

Andi

[LucD · Accepted solution]

Try changing that line into

@{N="Tags Host";E={(Get-VMhost -VM $_ | Get-TagAssignment | select -ExpandProperty Tag).Name -join ','}} 

[vmware-oebb]

Hi Luc,

Thank you so much. Works perfect.

Andi