/build/static/layout/Breadcrumb_cap_w.png

Possible to have a custom ticket rule check against license compliance?

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   [ + ] Show comments

Answers (1)

Posted by: chucksteel 9 years ago
Red Belt
0
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. 
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ