/build/static/layout/Breadcrumb_cap_w.png
01/04/2010 2657 views
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


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.