Collecting information and store into a .cvs file

[omegasa]

Hi,

In my network there are many computers are in and many out of the net into a short period of time. I want to make a script that collect information(computer name, IP, MAC, RAM) about all systems and than store them into a .csv file that can be imported in Excel or into a database.
Can someone tell me which objects must I use and how can I save information into .csv file ?

Thanks in advace

 

[dm4ever]

There are plenty of WMI scripts posted here and in other forums to gather the information you are looking for. You can also check out this:

http://managepc.net/

WMI Classes to consider: Win32_ComputerSystem, Win32_NetworkAdapterConfiguration, Win32_OperatingSystem

To save to a .csv file use FileSystemObject

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[WhoKilledKenny]

Don't forget you can also pipe your output via the command line.
Somewhere in your code:
eg. WscriptEcho strComputer & ", " & Item.CPU & ","

Then when you run the script....

c:\cscript ServerCPU.vbs > CPUReport.csv

 

[omegasa]

Can someone recommend me a free VBScript ebook ? Or a site from which I can download one ? ON the Internet I've found only splited information.

Thanks

 

[PHV]

Have a look here:

http://www.microsoft.com/downloads/...48-207D-4BE1-8A76-1C4099D7BBB9&displaylang=en

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dm4ever]

The link PHV is very useful. If you want to look at examples you can look here:

http://www.microsoft.com/technet/scriptcenter/default.mspx

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid