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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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.
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share