Revision 1

Date: 2007-07-23

OBSOLETE - HISTORIC USE ONLY

Features

• inventory_software table to represent a piece of software.
• inventory_license table to keep track of software licenses. There is one license key per license. There is one license per each software.
• Some software licenses are for many pieces of software. eg. Microsoft Office 2007 licenses are valid for Microsoft Office XP, Microsoft Office 2003, and Microsoft Office 2007. However, the maximum number of installations is fixed regardless. Use the inventory_volume_license to group multiple licenses into one set.
• inventory_installation links the license and the computer.

Limitations

• Some licenses can work with multiple pieces of software. e.g. GPL. This is not properly reflected in the model.
• Some licenses don't really need to be tracked. e.g. for software that comes free with Windows. Also, open source licenses don't really need to be tracked. There is no way of finding what software is installed except via the license.