Posted: January 19, 2004
Create a Software Inventory Database
Step 2: Performing the Software Inventory
requires Flash 6 player
It's important to store all software information in a single location, either in a spreadsheet or in a database.
This spreadsheet or database should also be able to accommodate license information. In addition, your customer should be able to easily enter in new software acquisition information or make changes to the inventory if a workstation is retired.
The database (or spreadsheet) should capture the following information:
Number of Installs
This information should link to a user record for each employee, so at all times your customer can determine the total number of installations and which employees have the software installed on their workstations.
Number of licenses per each licensing method (OEM, Retail, or Volume Licensing program)
The license information should be related to the software title.
If your customer prefers to use a database, you may also suggest creating a secure, online interface that your customer’s IT staff can use to enter information for new software titles as they are received and installed. If creating an interface, make sure to design a tool that will be easy and intuitive for employees to use. If it’s not easy, employees will not likely use the tool and your customer’s software and license inventories will quickly become out-of-date.