Thank you! I took what you provided and slightly modified it, I removed the error handling part too where it checks to see if there are tags in that category. I did this because I was getting an error stating:
"Index operation failed; the array index evaluated to null.
At D:\Scripts\getVMTagsOnHost\getVMTagsOnHost.ps1:28 char:9
+ $vmObj[$_.Tag.Category.Name] = $_.Tag.Name
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : NullArrayIndex
Index operation failed; the array index evaluated to null."
I figured out it threw these errors up if a VM didn't have a tag in the category it was processing. I'll play around with the error handling but this is not a production script so I'm not too concerned about it. Below is what my script looks like in full, and works like a charm. It's also MUCH faster than the way I was doing it previously, which was to do a Get-VM | Get-TagAssignment for each category for each VM.
$hst = Read-Host "Enter the ESXi Host FQDN name"
$catNames = 'Owner', 'Application', 'OS', 'Created By', 'Support Case', 'Date Created', 'Backup', 'Virtual Appliance'
$cat = Get-TagCategory -Name $catNames
$obj = @{
VM = ''
}
$catNames | ForEach-Object -Process {
$obj.Add($_, '')
}
Get-VMHost -Name $hst | Get-VM | ForEach-Object -Process {
$vmObj = $obj.Clone()
$vmObj.VM = $_.Name
Get-TagAssignment -Entity $_ -Category $cat | ForEach-Object -Process {
$vmObj[$_.Tag.Category.Name] = $_.Tag.Name
}
New-Object -TypeName PSObject -Property $vmObj
} | Select -Property (@('VM') + $catNames) | Export-Csv -Path ".\VM tags on $hst.csv" -NoTypeInformation -UseCulture
