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

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

3

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.

Answered 09/17/2012 by: chucksteel
Red Belt

Please log in to comment

Answers

2

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)

 

 

 

Answered 09/14/2012 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity