Would like to get email notification when a PC hasnt checked in for a set amount of days and/or when a PC has been removed from inventory.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

To create an alert for a specific PC you can use the Email Alerts in the Reporting tab. Create a new alert where system name = the target computer and Last Sync > 1 day (it doesn't matter what value you enter in the wizard, we're going to need to change the SQL anyway). Give the alert a name and recipient and save it.

On the list of alerts, click the alert you just created and look for the following in the query:

 LAST_SYNC > '1 day'

Modify this to read:

 LAST_SYNC < DATE_SUB(NOW(), INTERVAL 1 DAY)

You can change the number to reflect how long a machine doesn't sync before you get the alert. You'll probably also want to adjust the frequency of the alert since KACE will send an email every time the search matches.

You can also accomplish this with a report if you're looking to get alerts for multiple machines. The following SQL will give you all machines that haven't checked in for seven days:

 SELECT USER, NAME, IP, LAST_SYNC, OS_NAME FROM ORG1.MACHINE
WHERE LAST_SYNC < DATE_SUB(NOW(), INTERVAL 7 DAY);

I have a similar report that runs on the first of the month and shows me machines in the buildings I support (based on labels) that haven't checked in for one month.

To find when computers are deleted from the Inventory you can use the following SQL:

 SELECT * FROM ORG1.ASSET_HISTORY WHERE CHANGE_TYPE = "Deletion";

This query is more specific and would show you the computers deleted from the Inventory in the last seven days:

 SELECT * FROM ORG1.ASSET_HISTORY WHERE 
CHANGE_TYPE = "Deletion" 
and TYPE_NAME = "Computer"
and TIME > DATE_SUB(NOW(), INTERVAL 7 DAY);

You could create a report with this query and schedule it to be emailed to you once a week, or adjust it to once a day if you need that. 

Answered 09/19/2013 by: chucksteel
Red Belt

  • Awesome man thanks. The report works great. One question. I have the report created but how to i get it to email the report out to two separate users?
    • Reporting, Schedule Reports, Choose Action, Create a new Schedule.
Please log in to comment
Answer this question or Comment on this question for clarity