Dell KACE
AppDeploy

 

Asset Change History Report using Kbox 1000
2/10/2010 | Submitted By afzal
 
1. Logon to Kbox 1000 as Administrator
2. Select Reports
3. Under "Choose Action" dropdown select “Add New SQL Report”
4. Paste the following SQL statement under the “SQL Select Statement Box”
5. You may change the SQL statement interval of 10 days to some other values

SQL:

select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION
from ASSET
left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID
left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID
where
(ASSET_TYPE.ID = 5
and NOW() < DATE_ADD(ASSET_HISTORY.TIME, INTERVAL 10 DAY)
and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' and ASSET_HISTORY.DESCRIPTION not like '%Warranty%')
and
(ASSET_HISTORY.DESCRIPTION like 'Found software item%'
or ASSET_HISTORY.DESCRIPTION like '%remove%'
or ASSET_HISTORY.DESCRIPTION like '%change%')
order by TIME DESC

Printer Friendly Version
  
Problem? Question? Comment? Please, let us know!
Return to AppDeploySM Tips and Tricks.