We have various software assets set up that are tied to license limits, e.g. Adobe Acrobat / Microsoft Office / etc.

Is it possible to have an email alert sent when the number of software installs reaches the limit / threshold? Or do we just have to keep checking it in Kbox?

Thanks.
0 Comments   [ + ] Show Comments

Comments

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
I think this possible, i will upload the procedure after checking it.
Answered 03/12/2010 by: afzal
Fourth Degree Green Belt

Please log in to comment
0
Use the following query in the computer notification, and select the frequency it will give u the list of record where license remaining is zero or less then zero.

select *
from(SELECT ASSET.NAME AS NAME,
COUNT(DISTINCT MACHINE_SOFTWARE_JT.MACHINE_ID) AS INSTALLED,
ASSET_DATA_7.FIELD_1 AS OWNED,
ASSET_DATA_7.FIELD_1 - COUNT(DISTINCT MACHINE_SOFTWARE_JT.MACHINE_ID) AS REMAINING,
A8.NAME AS VENDOR,
ASSET_DATA_7.FIELD_9 AS PURCHASE_ORDER_NUM,
ASSET_DATA_7.FIELD_11 AS NOTES
FROM ASSET_DATA_7
LEFT JOIN ASSET ON ASSET_DATA_7.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=7
LEFT JOIN ASSET_ASSOCIATION J8 ON J8.ASSET_ID = ASSET.ID AND J8.ASSET_FIELD_ID=8
LEFT JOIN ASSET A8 ON A8.ID = J8.ASSOCIATED_ASSET_ID
LEFT JOIN ASSET_ASSOCIATION J2 ON J2.ASSET_ID = ASSET.ID AND J2.ASSET_FIELD_ID=2
LEFT JOIN ASSET A2 ON A2.ID = J2.ASSOCIATED_ASSET_ID
LEFT JOIN ASSET_ASSOCIATION JX2 ON JX2.ASSET_ID = ASSET.ID AND JX2.ASSET_FIELD_ID=2
LEFT JOIN ASSET AX2 ON AX2.ID = JX2.ASSOCIATED_ASSET_ID
LEFT JOIN MACHINE_SOFTWARE_JT ON (SOFTWARE_ID = AX2.MAPPED_ID OR SOFTWARE_ID IN
(SELECT SOFTWARE_ID
FROM ASSET_DATA_6 JOIN SOFTWARE_LABEL_JT
ON LABEL_ID = ASSET_DATA_6.FIELD_10001
WHERE ASSET_DATA_6.ID = AX2.ASSET_DATA_ID))
GROUP BY ASSET_DATA_7.ID ORDER BY REMAINING,NAME asc) A
where Remaining <=0
Answered 03/12/2010 by: afzal
Fourth Degree Green Belt

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