A couple of options (including one that you don't need):
Write your own database; Perhaps a simple application using SQLite. (Not very attractive, but not difficult)
You just need an application that allows you to create name: value pairs and assign them to groups. A custom address book will work as a last resort. Each contact can be a program name or a customer name with a license / sequence as data. Then you can group a computer, client, etc.
This sounds like a classic problem that Access (and similar programs) were designed to solve. You start with access, use it for several years, and then later hire someone to transfer data to the user application when you outgrow this solution.
I would really like to try and use the address book program for this. (Note: I am using Apple's address book program, which is intended for function references). It allows you to customize fields, notes, and groups. The disadvantage is that you need to do more work: search for a part of the serial number to make sure it is not in use by manually adding a note to the two โcontactsโ indicating the transfer of the license from one to the other.
On the other hand, if license tracking your own software is key for your company, it is probably worth the time and money to develop a custom application on top of an SQL database. Write down a list of everything you want to do. Go back and write down any rules or restrictions (for example, can two or more machines have the same license?). The database schema and programming rules will drop out directly from this document.
Another idea: programs that track books, dvds, etc. First of all, these are the ones that allow you to take notes about when you provide them to people.
Harvey
source share