[SQL][zip] Software Change Log by Machine (Last 30 days)
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
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
