Hello, I'm still new to Kace and am trying to do somthing probably very simple.

I'd like to create an email notification that, once a day at 8am, will see any computers that have been disconnected for 12 hours, and send an email. I saw the last sync option but I don't seem to be able to understand the criteria it needs.

 

Any help is greatly appreciated! Thanks,

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

4

First, go to Reporting > Reports > Choose Action > Add New SQL Report and populate it with this info and then hit Save.  This report will show all clients with agent disconnect times greater than 12 hours, with the most recently connected machines at the top.

***Title***
Agents Disconnected for 12+ Hours

***Description***
Agent (Custom)

***SQL Select Statement***
SELECT MACHINE.NAME AS SYSTEM_NAME,IP,LAST_SYNC FROM MACHINE 
WHERE DATEDIFF(NOW(), LAST_SYNC) > 0.5
ORDER BY LAST_SYNC desc

***Show Line Number Column***
x

_____________________________________

Next go to Reporting > Schedule Reports > Choose Action > Create a New Schedule, populate the fields.  To select the report you just created, just start typing the name "Agents Di" in the Report to Schedule - Filter field and then it should appear in the drop-down box above that.  Click the drop-down and select the report by name to select.

I'm assuming the rest should be straightforward, but if you get stuck on anything just let us know.

Hope that helps!

John

 

Answered 04/12/2012 by: jverbosk
Red Belt

  • This is great! Just tested it, and sure enough pulls the info as reuqested.

    Thank you very much!
  • How would I have it pull from a certain IP segment? For an example: 10.19.*.*
Please log in to comment
Answer this question or Comment on this question for clarity