Track inventory changes in Kace 6.0
My goal is to get emailed reports whenever there are any hardware changes in a workstation.
I found some posts related to this
http://www.itninja.com/blog/view/how-to-get-an-alert-in-case-of-inventory-changes-on-the-kace-k1000
http://www.itninja.com/blog/view/how-to-get-alerts-on-inventory-changes-and-the-related-report-for-the-k1000-5-4
http://www.itninja.com/question/k1000-email-alerts-when-changes-occurred-in-the-hardware-inventory
But all of them use the variable ASSET_HISTORY.DESCRIPTION and that doesn't seem to work anymore.
Can anyone assist me with this, I promise many cookies in your future.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
9 years ago
This query will show changes over the past month, you can adjust the interval accordingly for how often you want to run the report:
SELECT ASSET_HISTORY.*
FROM ORG1.ASSET_HISTORY
WHERE TIME > DATE_SUB(NOW(), INTERVAL 1 MONTH)
and FIELD_NAME in ('MACHINE_DISKS', 'MONITOR', 'CDROM_DEVICES', 'VIDEO_CONTROLLERS', 'RAM_TOTAL', 'SOUND_DEVICES', 'PROCESSORS')
and NAME = "computername"
I have filtered it to only field changes that I identified as hardware changes. The ASSET_HISTORY table contains a lot of other information as well that would make this report much larger. The MACHINE_DISKS changes are also frequent since this includes changes to disk space and when users have an external drive attached when the inventory runs.
Comments:
-
So I created this report and enabled it to run every 15 minutes. We have a virtual machine that I went in and increased the Ram by 2GB and haven't received any email.
Just to confirm I'm adding the notification correctly:
Under Inventory->Devices I click on Notification
I create a random search that returns some computers, add a title and recipient and click Create.
Under Reporting->Notifications I click into the newly created notification then click the line that says "To edit the Notification using this editor, Click Here". Then I enter your SQL code. - vitalym 9 years ago-
I have never created an alert in that way, instead I create a report and then schedule the report to run on a schedule. When you create the report be sure to change the last line to include the name of the machine you want to monitor. If you also want an aggressive schedule to notify of changes you'll want to change the interval to match how often the report runs. - chucksteel 9 years ago
-
Thank you this worked. Is there a way to run it against all computers? - vitalym 9 years ago
-
If you remove the last line it will include all computers. - chucksteel 9 years ago
