Get information about all the Windows desktop computers in your environment that are connected to your Windows update server and export it to a csv

getDesktopInfoFromWsus.ps1

#requires PoshWSUS
Import-Module PoshWSUS
$wsusServer = read-host -promt "enter WSUS server name"
Connect-PSWSUSServer $wsusServer -Port 80
$pcs = Get-PSWSUSClient | Where-Object { -not ( $_.osdescription -like "Windows Server*" )} 
foreach ($pc in $pcs) { 
    $pc | Add-Member -notepropertyname department -NotePropertyValue $($pc.requestedTargetGroupNames | select -First 1) 
}  

$pcs | select fulldomainName,make,model,osdescription,department | Export-Csv computerInventoryInfo.csv