I've implemented license tracking for my MS Select items, as per the manual, and it's great - an accurate picture for the first time ever. Wonderful.

However, I'd like to have a software item for my Device CAL licenses for Windows Server and Exchange Server. From the "installed" point of view all I need is one count for each non-server computer, as every machine needs a CAL. But there's no one item that every computer has installed that I can hang this on.

Has anyone done this successfully?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1
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.
Answered 08/17/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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.
Answered 08/17/2011 by: Acedashdog
Purple Belt

Please log in to comment
0
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'
Answered 08/17/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity