Lists machines that have had software installed or removed in the last 30 days. Can be modified to include specific software titles as well as modified for longer or shorter time periods.

SELECT AH.TIME, AH.DESCRIPTION, concat(M.NAME,' [',M.ID,']') as MACHINE_NAME FROM MACHINE M, ASSET_HISTORY AH, ASSET A
where AH.ASSET_ID = A.ID
and M.ID = A.MAPPED_ID
and A.ASSET_TYPE_ID = 5
and AH.DESCRIPTION like '%Software%'
and NOW() < DATE_ADD(AH.TIME, INTERVAL 30 DAY)
order by AH.ASSET_ID, AH.TIME

Attachment

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity