vSphere PowerCLI 6.0 script to dump guest attributes and notes from multiple vCenters

dumpCustomAttribsNNotes.ps1

$serverCSV = import-csv ".\vCenterServers.csv" 

$outputFilename = “.\exported-attributes-value.csv”

Remove-Item $outputFilename

foreach($serverData in $serverCSV) {

    Connect-VIserver -server $serverData.server -User $serverData.username -Password $serverData.passwd 

    $valueList =@()
    get-vm | % {
        for($i = 0; $i -lt $_.CustomFields.Count; $i ++ ){
            if ( $_.CustomFields.Values[$i] ) { 
                $row = “” | Select vCenter, VMname, FieldKey, FieldValue
                $row.vCenter = $serverData.server
                $row.VMname = $_.Name
                $row.FieldKey = $_.CustomFields.Keys[$i]
                $row.FieldValue = $_.CustomFields.Values[$i]
                $valueList += $row
            }

        }
        $curVMGuest = Get-VMGuest $_
        if ( $curVMGuest.VM.Notes ) { 
            $row1 = “” | Select vCenter, VMname, FieldKey, FieldValue
            $row1.vCenter = $serverData.server
            $row1.VMname = $_.Name
            $row1.FieldKey = "Notes"
            $row1.FieldValue = $curVMGuest.VM.Notes
            $valueList += $row1
        }
    }
    $valueList | Export-Csv -Append $outputFilename -NoTypeInformation

    Disconnect-VIServer –server “*” -Confirm:$False
}