Email notification by last sync for disconnected computers?
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,
Answers (1)
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
