KACE Product Support

Yes. Create custom software and license assets for the CAL. Then write a custom ticket rule to calculate and modify the install count field on the asset.

Ohhkay... the first bit's easy enough, but how do I make a ticket rule update an asset once for each PC? That's well beyond my SQL I'm afraid.

Here is an example rule that will update the asset for Windows Client OS CALs. We run this rule daily. It's basically finding all machines that are running a non-server version of Windows. Then, it adds them up and changes the total count for the license asset. The select query should work as-is for you, but the update query will need adjusting. The asset tables are different in each KBOX's database, so the table number (i.e. ASSET_DATA_7) may not be correct. The same can be true of the field name (i.e. FIELD_101). The license asset name in the where clause of the update statement will obviously be different as well.

Select Query:
SELECT COUNT(M.ID) AS ID FROM MACHINE M
WHERE M.OS_NAME like '%Windows%' AND M.OS_NAME not like '%Server%'

Update Query:
UPDATE ASSET_DATA_7 AD
JOIN ASSET A ON (A.ASSET_DATA_ID = AD.ID)
SET AD.FIELD_101 = <TICKET_IDS>
WHERE A.NAME = 'SWLA - Microsoft Windows Client OS'