Analyzing the Data
After inventory collection is complete, you can review individual inventory files in Notepad. Each text file contains sections, such as ComputerSystem and IDEController, that represent a characteristic of the inventoried computer. Not every inventory file contains every section, however. For example, if you inventory a computer that contains a SCSI controller but no IDE controller, the corresponding file will contain a SCSIController section but won't contain an IDEController section.
Also, a system's OS version will affect the amount of hardware that the inventory file displays. For example, a Win98 system's inventory file won't contain a PhysicalMedia section because the Win32_PhysicalMedia WMI class is available only on Windows 2003 or XP machines.
Within the available sections, you might notice some items with values listed as Not available. This value occurs when a hardware manufacturer hasn't stored data for a particular WMI property or when WMI can't locate a property's value.
The inventory analysis demonstrates that a computer's OS and hardware components, as well as the properties of each hardware device, create exceptions to uniform inventory collection across all computers. Still, the script will leave you with a rich collection of useful inventory information.
Building the Report
Telling members of the Accounting team that they can go to your hardware-collection directory to view 5000 tiny text files containing the information they want probably won't sit too well with your boss. The next step, then, is to create a hardware inventory report. Enter our trusty report agent, BuildReport.vbs. The report agent reads each file, locates sections of inventory data, then writes the data to individual worksheets in an Excel workbook named InvReport.xls. (For details about how the script works, see the sidebar "How the Report Agent Works," page 4.)
Excel is a good choice for consolidating the inventory data for several reasons. First, Excel is widely available. Second, the application lets you easily create rich reports and analyze collected data. And third, most people who work with inventory reports are familiar with Excel spreadsheet operation and analysis.
Before running the report agent, you must make two minor changes to lines 9 and 10 of BuildReport.vbs. Line 9 contains the strInvFilePath variable and specifies the path to the hardware-collection directory; Line 10 contains the strReportPath variable and specifies the location in which you want the script to create InvReport.xls. Change these values to suit your environment.
Before you run BuildReport.vbs, you need to know three details about the report agent. First, the agent relies on the Excel application object. Therefore, make sure that Excel is installed on the computer on which you'll run the agent.
Second, I intentionally wrote the agent to display a processing message as it parses each inventory file; this regular output assures you that the script is successfully processing the inventory files. (When I ran the agent on a 1GHz Pentium III computer with 512MB of memory, each file required approximately 3 seconds to process.) Because of this output, you must use WSH's CScript host engine to run the script so that the script will continue after it processes each record. If you were to use WSH's WScript host engine, you'd need to click OK each time—a lot of clicking if you have 10,000 inventory files to process. To run the report agent with CScript, either make CScript your default host or open a command prompt, go to the directory that contains the report agent, and type
cscript buildreport.vbs
Third, consider the time the report agent will take to run before you begin the process. If each file takes 3 seconds to process and you have 10,000 files, complete report generation will require 30,000 seconds, or 8.3 hours. Therefore, consider running the report at night and on a fast computer that isn't busy completing other tasks.
Figure 1 shows an example of the output you'll see when the report agent finishes its work. (To show as much data as possible in this figure, I've hidden toolbars and reduced cell width.) The figure shows the Computer Systems worksheet; the workbook includes 14 worksheets in all, one for each section of inventory data: Computer Systems, Page Files, RAM, SCSI Controllers, IDE Controllers, Disk SerNums, Removable Media, Fixed Disks, Processors, NICs, Monitors, Video Adapters, Motherboards, and BIOS. You can modify the inventory agent and report agent scripts to collect more data from each computer if you want.
Inventory in a Nutshell
You now have a lightweight yet verbose inventory-collection and -reporting tool—and for nothing more than a subscription to this newsletter. I hope you, your boss, and the accounting department will all be thrilled.
End of Article
Prev. page
1
[2]
next page -->
