Script Inventories Remote Computers and Writes the Information to a Database

 Executive Summary:

Computer_Inventory.vbs retrieves inventory information from remote computers and writes that information to a Microsoft Access database. To do this, the script uses Windows Management Instrumentation (WMI) objects to retrieve information from the remote computers and ActiveX Data Objects ( ADO) and OLE DB to create the database and populate it with data.

At my company, administrators often need to create reports detailing inventory information (e.g., OS version, OS serial number) about the remote computers they manage. To help them, I wrote a script, Computer_Inventory.vbs, that retrieves this information from remote computers and writes it to a Microsoft Access database. All the administrators need to do is create an input file that lists the computers they want information for, run the utility, then query the database that the script creates and populates. . . .