Hi All,
Further to this question ->
http:/Q_22703172.htmlI am building a CRM database to use for my company which is primarily network services and consulting. What I want to do is build an asset register, and within that, build a software register. The idea is that it will look like this;
Client A has these machines
ServerA is a Server and is installed with Software1 as the OS and Software2 as the primary application, it also does the following Roles and has the following configuration
ServerB is a Server and is installed with Software1 as the OS and Software3 as the primary application
Workstation1 is a workstation and is installed with Software4 as the OS and Software5 and Software6 as the primary application.
Etcetera
Now, what I want to also be able to do is be able to see, ok, ClientA has 14 copies of Software1 and 14 copies of Software2, they have 20 copies of Software4 and so on. This way I can keep a track of serial numbers, licenses, SA expiration, purchase dates, and most importantly, compliance.
So, how am I suppose to structure this sucker?
Currently I have it as follows;
Software is set out as type, so Operating Systems, Applications, Utilities
SoftwareAsset is set out as the actual Application, so Windows 2003 Server, Office 2003, Acrobat 6
Asset is set out as the device, so Server1, and so on.
Can anyone think of a better way than this? If I can't see how many copies of Windows 2003 Server a customer has, then there is little point in building a separate entity, I could just use picklists.
Thanks in advance
-red
Start Free Trial