I feel that it is quite tedious to create separate windows/forms for each CI. Our current ticketing system allows us to select an "Asset Type Name" and manually enter the rest of the items details pertaining to that selected item. If we need to query a particular asset type all we do is filter search to only Asset Type Name that contains a particular item.
Screenshot is shown below:
Another idea in mind was to create a separate drop down menu for one CI. For example, Workstation window has a drop down menu called "Asset Type" and it has "Laptop" and "Desktop" on it. Asset windows also has a drop down menu called "Asset Type" and it has "Signature Pads", "Aircards", and "USB drives".
If I need query a list of aircards for example, I should be able to get a list of aircards. I was wondering all the items on every CI "Asset Type" are store in one table? Sometimes we like to add more item types. Let me know your thoughts about this. Any help is always appreciated!