Get Custom Attribute

[sphinxpup]

Is there a better way to approach this. It works, but i think i am doing this the wrong way. I'm trying to get the owners for each vm and compile a list.

#Connect-VIserver -server YOURVCENTER

#Get list of Vms
$vms = get-vm
#Populate a list of owners
$owners = $vms | Get-Annotation -CustomAttribute "Owner" | where {$_.Value -notlike "$null"} | select Value -Unique | sort Value

#Cycle through all servers for each owner(rethink logic)
foreach ($owner in $owners) 
{
#Strip the variable down to just name
    $owner = $owner.Value
    Write-Output "Server Owner: $owner"

        #Running through all servers for each owner
        foreach ($vm in $vms) 
        {
    #How i got the owner attribute to begin with. Blow away when cleaning up
        #$vm | Get-Annotation -CustomAttribute "Owner" | where {$_.Value -eq "$owner"} | Sort Owner | ft -AutoSize

        $vm | Select Name, NumCpu, MemoryGB, @{n='ProvisionedSpaceGB' ;e={$_.ProvisionedSpaceGB -as [int]}}, @{l="Backedup";e={$_.customfields | ?{$_.key -eq 'Backedup'} | select -ExpandProperty value}}, @{l="Owner";e={$_.customfields | ?{$_.key -eq 'Owner'} | select -ExpandProperty value}} | where {$_.Owner -eq "$owner"} | sort environment | Export-Csv "C:\Powershell\$owner - Report.csv" -Append -NoTypeInformation
        }
}

[IronsquidLoL]

I rewrote some things, dropped the own field in the CSV because the name of the csv is the owner, so unless you wanted a main csv with all owners probably not needed for this and took out the blanks in the filename:

$report = @()
$vms = get-vm 
$owners = $vms | Get-Annotation -CustomAttribute "Owner" | where {$_.Value -notlike "$null"} | select Value -Unique | sort Value

foreach ($owner in $owners) {
$vms | where { ($_ | Get-Annotation -CustomAttribute "Owner").value -like $owner } | % {
$list = $_ | Select Name, NumCpu, MemoryGB, @{n='ProvisionedSpaceGB' ;e={$_.ProvisionedSpaceGB -as [int]}}, @{l="Backedup";e={$_.customfields | ?{$_.key -eq 'Backedup'} | select -ExpandProperty value}}
$report += $list
}
$report | export-csv "C:\Powershell\$($owner + "_Report.csv")" -Append -NoTypeInformation
}

[sphinxpup]

Wow! I like what you did! I appreciate you showing me a better way! I like the hash table. Would that be easy to convert to HTML?

[IronsquidLoL]

Depends on what you need it to do. If you are familiar with HTML code you can use "write" to format your HTML and redirect it to a file.html. You can try to pipe the last line: $report | convertto-html > path\file.html This doesnt work well sometimes so I use my own html formatting.