KACE Product Support

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.

I'm not sure if I can help you on the email notification, but you can query the event log and export it to a .txt file, and then have Kace inventory that file.

Powershell Script:

$file= "c:\temp\file.txt"

Get-WinEvent -FilterHashtable @{logname='application'; id=1033;}|

format-table timecreated, providername,message -wrap|out-file $file

 

Custom Inventory Rule:

ShellCommandTextReturn(cmd.exe /c type C:\temp\file.txt)