/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Community Chosen Answer


Answers

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.
Answer this question or Comment on this question for clarity

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