Extract computer hardware information from WSUS
A question was asked in the WSUS Mailing List (hosted by Shavlik Technologies on www.patchmanagement.org) – I am using WSUS 2.0 and I was wondering if there was a way to extract the computer hardware information it collects? Oh yes, this is possible. You can extract computer hardware data in table ‘dbo.tbComputerTarget’ in SUS database (SUSDB). You can query for the following information; TargetID ComputerID SID LastSyncTime LastReportedStatusTime LastReportedRebootTime IPAddress FullDomainName OSMajorVersion OSMinorVersion OSBuildNumber OSServicePackMajorNumber OSServicePackMinorNumber OSLocale ComputerMake ComputerModel BiosVersion BiosName BiosReleaseDate ProcessorArchitecture ClientGuid RequestedTargetGroupName IsRegistered For instance, you can query it directly using SQL … Continue reading Extract computer hardware information from WSUS