Report that shows uninstalls but not updates?
I wrote the following SQL script to show me the un-installs in my system:
SELECT MACHINE.USER_FULLNAME, MACHINE.User, ASSET_HISTORY.NAME, ASSET_HISTORY.TIME, ASSET_HISTORY.VALUE1 as Software, ASSET_HISTORY.VALUE2 as Version, ASSET_HISTORY.CHANGE_TYPE
FROM MACHINE JOIN ASSET_HISTORY ON MACHINE.Name =ASSET_HISTORY.NAME
WHERE FIELD_NAME = 'SOFTWARE'
AND CHANGE_TYPE = 'No longer detected'
AND TIME > DATE_SUB(CURDATE(), INTERVAL 7 DAY)
ORDER BY ASSET_HISTORY.VALUE1 ASC;
but the problem with that is that most of the software that appears there is software that was updated, even minor updates. Any idea how to modify it so it doesen't show updates?