List Archives

This forum is an archive of all posts to our mailing list over the past few years. The forum is set read only therefore to contribute you will need to join our list community. See more info about this here.

When subscribed to the list you should use your standard email client to send your posts to ActiveDir@mail.activedir.org.

List Archives

Unanswered Active Topics

Forums Search

Forums >ActiveDir Mail List Archive >List Archives

Subject: OT: Asset inventory -- from WSUS listserve[Fwd: Re: [ActiveDir] [wsus] WSUS Asset Report]

Prev Next

You are not authorized to post a reply.

Author

Messages

sbradcpa

Posts:496

05/02/2006 7:43 AM
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: Richard_May@xxxxxxxxxxx Reply-To: WSUS Mailing List To: WSUS Mailing List "Andy Gibson" 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 leave-wsus@xxxxxxxxxxxxxxxxxxxx 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 owner-wsus@xxxxxxxxxxxxxxxxxxx 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/

You are not authorized to post a reply.

Forums >ActiveDir Mail List Archive >List Archives > OT: Asset inventory -- from WSUS listserve[Fwd: Re: [ActiveDir] [wsus] WSUS Asset Report]

ActiveForums 3.7

Syndicate

Friends

List Archives

List Archives

Friends

Members

Articles

Related Links

Ads