WSUS : Export Computer

Exporting All Attributes

Get-WSUSComputer -all

Selective Data Export

Get-WSUSComputer | Select-Object FullDomainName,IPAddress,ComputerRole

Attributes availables

• Id
• FullDomainName
• IPAddress
• Make
• Model
• BiosInfo
• OSInfo
• OSArchitecture
• ClientVersion
• OSFamily
• OSDescription,
• ComputerRole,
• LastSyncTime,LastSyncResult
• LastReportedStatusTime
• LastReportedInventoryTime
• RequestedTargetGroupName
• ComputerTargetGroupIds
• RequestedTargetGroupNames
• ParentServerId
• SyncsFromDownstreamServer

Exporting to CSV

$CSVfile = $PSScriptRoot+"\ComputerNewWSUS.csv"
Get-WSUSComputer | Select-Object FullDomainName,IPAddress,ComputerRole | export-csv $CSVfile