K1000 New software notification
is there a way to create an email notification so that I know when a certain computer adds new software? I am not looking for a specific title-just any new software loaded
Community Chosen Answer
This report pulls from the Asset History to show new installs for computers in a specific lab:
SELECT ASSET_HISTORY.ASSET_ID, ASSET_HISTORY.TIME, ASSET_HISTORY.DESCRIPTION, ASSET_HISTORY.USER_TEXT, MACHINE.NAME FROM ASSET_HISTORY JOIN ASSET ON ASSET.ID = ASSET_HISTORY.ASSET_ID JOIN MACHINE ON ASSET.NAME = MACHINE.BIOS_SERIAL_NUMBER WHERE DESCRIPTION LIKE '%Found software item%in inventory.%' AND ( (DATE(ASSET_HISTORY.TIME)> DATE_SUB(NOW(), INTERVAL 1 day) AND DATE(ASSET_HISTORY.TIME)<= NOW())) AND MACHINE.NAME LIKE 'lib-ic-%'
To limit the report to one specific machine replace the AND MACHINE.NAME LIKE 'lib-ic-%' with AND MACHINE.NAME = 'machinename'.
Once the report is save you can then schedule it to be emailed to you daily.