Hey Andy,
You can query that info directly using Query Analyzer or OSQL. The
query you would use is:
USE SUSDB
SELECT FullDomainName, ComputerMake, ComputerModel
FROM tbComputerTarget
Hope that helps.
Evan Waite
Systems Administrator
Interactive Tracking Systems Inc.
-------- Original Message --------
Subject: Re: [wsus] WSUS Asset Report
Date: Tue, 2 May 2006 10:35:47 -0700
From: [EMAIL PROTECTED]
Reply-To: WSUS Mailing List <[EMAIL PROTECTED]>
To: WSUS Mailing List <[EMAIL PROTECTED]>
"Andy Gibson" <[EMAIL PROTECTED]> wrote on 05/02/2006 06:58:09:
Hello Everyone,
WSUS uses WMI to capture some basic asset information when it queries
PCs/Servers for patch status (Make, model, etc.). Does anyone know of
a way to run a report of this data? We're looking for a way to
capture make and model of the PCs in our enterprise.
Use Excel or Access. Import the table dbo.tbComputerTarget from your
database (SUSDB).
RM
---
This list is also available via RSS:
http://listserver.patchmanagement.org/read/rss?forum=wsus
WSUS Mailing List is hosted by Shavlik Technologies (http://www.shavlik.com)
To unsubscribe send a blank email to [EMAIL PROTECTED]
If the above unsubscribe doesn't work, view your email headers
(in Outlook, open message, View-Options) and send a blank email to the address
listed in the header that starts with 'List-Unsubscribe'.
If you are unable to unsubscribe via the above email addresses, please send an
email to [EMAIL PROTECTED] and asked to be removed from the list.
--
Letting your vendors set your risk analysis these days?
http://www.threatcode.com
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
