Re: need to do a domain inventory, but can't afford SMS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Torgeir Bakken (MVP) (Torgeir.Bakken-spam_at_hydro.com)
Date: 02/12/04


Date: Thu, 12 Feb 2004 05:24:05 +0100

Gerry Voras wrote:

> I am going to inherit very soon a 250+ workstation AD domain. One of the
> 1st things I'm going to need to do is accomplish a hardware and software
> inventory of all the equipment. However, my budget request for SMS (which
> I'm used to) was denied. I've compiled a bunch of SMS, DMI, and SNP trap
> tools over the years -- so my questions are:
>
> 1) any freeware tools available that I can use to take advantage of my
> existing stuff?
> 2) any other tools I should be considering instead (free or low cost?)
>
> Thanks!

Hi

For inventory to a csv file using WMI from vbscript (WMI comes default with
WinME, Win2k and WinXP), in the quickFIND field, search for:

poor mans sms

at Win32 Scripting [Clarence Washington]
http://cwashington.netreach.net

for a good example of this written by Steve Pyatt that you can use as a start
point.

Here is another one:

Using WMI for Inventory Management
http://www.serverwatch.com/tutorials/article.php/1475601

"A WSH script using VBScript is explained. The script uses
WMI to query a computer for some predetermined information.
The acquired information is written to a database using ADO."

The free AIDA32 is also an option.

http://www.aida32.hu/aida32.php

It can do automatic audit (e.g. using a logon script) via command-line
switches and save results to a file in various formats like HTML, CSV
or XML, or put it in a database (it has ADO/ODBC database support)

5.1 Command-line Mode
http://www.aida32.hu/proguide/en/proguide.htm#commandline_mode

AIDA32 network audit in practice
http://www.aida32.hu/aida-articles.php?n=002&lang=en

Using SQL databases for AIDA32.
http://www.aida32.hu/aida-articles.php?n=003&lang=en

--
torgeir
Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of the 1328 page
Scripting Guide: http://www.microsoft.com/technet/scriptcenter


Relevant Pages

  • Re: Is this possible with a script?
    ... The information is basic windows information such as: ... For inventory to a csv file using WMI from vbscript (WMI comes default with ... at Win32 Scripting ... The acquired information is written to a database using ADO." ...
    (microsoft.public.scripting.vbscript)
  • Re: Script to collect Software and hardware inventory
    ... Using WMI for Inventory Management ... WMI to query a computer for some predetermined information. ... The acquired information is written to a database using ADO." ... torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway ...
    (microsoft.public.scripting.vbscript)
  • Re: WMI Reference
    ... You will be writing a complex custom application / script for that. ... A good way to get used to what Wmi is and the way it works is to use ... be detected by Sms, etc. ... Scriptomatic tool from the scripting tech center. ...
    (microsoft.public.sms.admin)
  • Re: Pipe Delimited files with headers
    ... but if you're happy with scripting and text ... Here's a sample VBScript that shifts data from a text file into a table ... 'a table in an MDB database without opening Access ... Dim oTDef 'As DAO.TableDef ...
    (microsoft.public.access.externaldata)
  • Re: 2 questions: uptime and last logged on users
    ... > For your computer uptime question: ... > ' Converts WMI Date and Time Format to standard date/time ... > torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway ...
    (microsoft.public.win32.programmer.wmi)