Hi,
I am unable to get IP Address and OS details in the below script, please help.
also I dont see any error
Script
$assigned = Get-VM | Get-TagAssignment
$tagCat = $assigned.Tag.Category.Name | Sort-Object -Unique
$report = $assigned | Group-Object -Property { $_.Entity.Name } |
ForEach-Object -Process {
$vm = $_
$obj = [ordered]@{
Folder = $vm.Group[0].Entity.Folder.Name
VM = $vm.Name
IP =$vm.Entity.Guest.IPAddress
OS =$vm.Entity.Guest.OSFullName
}
$tagCat | ForEach-Object -Process {
$cat = $_
$tags = ($vm.Group | Where-Object { $_.Tag.Category.Name -eq $cat }).Tag.Name -join '|'
$obj.Add($cat, $tags)
}
New-Object PSObject -Property $obj
}
$colTab = @{ }
$report | Get-Member -MemberType NoteProperty | Where-Object { 'VM', 'Folder', 'IP', 'OS' -notcontains $_.Name } |
ForEach-Object -Process {
$column = $report."$($_.Name)"
$columnMax = ($column | Where-Object { $_ -ne '' } | ForEach-Object {
$_.Split('|').Count
} | Measure-Object -Maximum).Maximum
$colTab.Add($_.Name, $columnMax)
}
$report | ForEach-Object -Process {
$row = $_
$obj = [ordered]@{
Folder = $_.Folder
VM = $_.VM
IP =$_.IP
OS =$_.OS
}
$colTab.GetEnumerator() | Sort-Object -Property Name | ForEach-Object -Process {
if ($_.Value -gt 1) {
$col = $_
$values = ($row."$($_.Name)").Split('|')
1..($_.Value) | ForEach-Object -Process {
$obj.Add("$($col.Name)-$_", $values[$_ - 1])`
}
} else {
$obj.Add($_.Name, $row."$($_.Name)")
}
}
New-Object PSObject -Property $obj
} | ft -auto
Output
| Folder | VM | IP OS Application | Department Owner |
| ------ | -- | -- -- ----------- | ---------- ----- |
| Testing | | | | HADOOP | | | | Hadoop | Ops | | Karl |
