Can I create an alert on the Dell Kace K1000 to send me an e-mail whenever someone installs piece of software?
I'm looking to see if the KBOX can do this. Alert me whenever some user installs something like logmein or something similar. I want the KBOX the next time it scans to send me an alert that this piece of software was installed on x machine with the domain user who installed it etc.
Community Chosen Answer
In 5.4 ASSET_HISTORY table is restructured and can provide this data much easier, faster and at a lower cost then before. Any query (report, etc) should also be easier to understand and maintain if you need to change it in the future.
Because you're talking about a group of software, I would like to create a label to track them all, but because SOFTWARE and ASSET_HISTORY are not strongly related enough I might miss some entries. If you did use a label and then you could modify the membership of your label and leave your report alone.
Here is an example in 5.4 where you use the following to schedule a reporty that runs once a day. It will only return results from the last 24 hours :
H.VALUE1 "Software Detected",
H.VALUE2 "Version Detected"
from ASSET_HISTORY H
join ASSET A on A.ID=H.ASSET_ID
join MACHINE M on M.ID=A.MAPPED_ID
H.TYPE_NAME = 'Computer'
and H.FIELD_NAME like 'SOFTWARE'
and H.CHANGE_TYPE = 'Addition'
and H.VALUE1 rlike 'logmein|vnc'
and H.TIME > date_sub(now(), interval 1 day) -- only results from last 24 hours
group by A.ID, H.VALUE1,H.VALUE2
order by M.NAME