We're setting up a "Software Request" in our Help Desk, and I was wondering if it is possible to create a custom ticket that would check the requested software against the KACE Appliance's software compliance functionality to see if we have any licenses available for that given piece of software. Logically, it sounds like it should be feasible, but I'm not seeing where to go about doing this.
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


Yes, this should be possible but it will be complicated. The number of licenses is stored in one of the ASSET_DATA_x tables, where x is the ID of the asset type that holds your license information. On my appliance that is ASSET_DATA_7. The field which contains the license count is FIELD_1 (again that might be unique to my appliance). Getting the number of uses licenses is much more complicated since I don't believe that is stored in the database, but rather it is generated on the fly based on the number of computers where the software is already installed. This gets more complicated because licenses can be associated with either the software catalog or with a software title.

If you don't have the reporting user and a tool like MySQL Workbench setup you will need to do that in order to figure this out. 
Answered 05/20/2015 by: chucksteel
Red Belt

Please log in to comment