/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Track inventory changes in Kace 6.0

11/17/2014 3425 views
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.
Answer Summary:
0 Comments   [ + ] Show comments

Comments


All Answers

0
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.

Answered 11/18/2014 by: chucksteel
Red Belt

  • 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.
    • 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.
      • Thank you this worked. Is there a way to run it against all computers?
      • If you remove the last line it will include all computers.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ