On Tuesday, November 28, 2006, Rights Management Services Client with Service Pack 2 (KB917275) was downloaded by WSUS Server as classified under Service Packs.
According to Brian Lich [MSFT], "The RMS client should be not offered via WSUS because it is not considered a critical update. We are investigating this."
The RMS client is offered on Windows Update and Microsoft Update to Windows 2000 and Windows XP computer as an Optional/Recommended update. It's also available on the Microsoft Download Center.
I have approved this update for INSTALL and so far I haven't seen any issue. Happy patching!
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 Query Analyzer or OSQL;
USE SUSDB
SELECT FullDomainName, IPAddress, ComputerMake, ComputerModel, BiosName, BiosVersion, OSMajorVersion, OSServicePackMajorNumber
FROM tbComputerTarget
Hope that helps! Happy patching.