KAPes musings !

WSUS Client Inventory

Posted by kapes on September 14, 2009

Download and install Microsoft SQL Server Management Studio Express on your WSUS 3 Server
Use Windows Authentication to connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Then run following query locally from WSUS server.

SELECT [Name]
,[IPAddress]
,[LastSyncResult]
,[LastSyncTime]
,[LastReportedStatusTime]
,[OSArchitecture]
,[Make]
,[Model]
,[BiosName]
,[BiosVersion]
,[BiosReleaseDate]
,[OSMajorVersion]
,[OSMinorVersion]
,[OSBuildNumber]
,[OSServicePackMajorNumber]
,[OSDefaultUILanguage]
FROM [SUSDB].[PUBLIC_VIEWS].[vComputerTarget]

if you are command line junkie use SQLCMD.exe

Prerequisite is : SQL Native client

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: