ITNinja

Feel free to improve on the filter if you find I have missed out any hardware change.

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 30 DAY)
and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' )
and
(
ASSET_HISTORY.DESCRIPTION like 'video controllers changed from%'
or ASSET_HISTORY.DESCRIPTION like 'mac changed from%'
or ASSET_HISTORY.DESCRIPTION like 'processor changed from%'
or ASSET_HISTORY.DESCRIPTION like 'ram total changed from%'
or ASSET_HISTORY.DESCRIPTION like 'registry max size changed from%'
or ASSET_HISTORY.DESCRIPTION like 'ip changed from%'
or ASSET_HISTORY.DESCRIPTION like 'cd devices changed from%'
or (ASSET_HISTORY.DESCRIPTION like '%changed from%' and ASSET_HISTORY.DESCRIPTION like '%disk%')
or (ASSET_HISTORY.DESCRIPTION like '%changed from%' and ASSET_HISTORY.DESCRIPTION like '%bios%')
or (ASSET_HISTORY.DESCRIPTION like '%changed from%' and ASSET_HISTORY.DESCRIPTION like '%ram%')
)
order by TIME DESC