{"id":8371,"date":"2024-10-31T09:37:07","date_gmt":"2024-10-31T09:37:07","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=8371"},"modified":"2024-10-31T09:37:09","modified_gmt":"2024-10-31T09:37:09","slug":"labtech-monitor-to-alert-of-devices-offline","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/labtech-monitor-to-alert-of-devices-offline","title":{"rendered":"Labtech Monitor to Alert of Devices offline"},"content":{"rendered":"\n<p><br>Interval: 6 Hours<br>Send Fail After Success<\/p>\n\n\n\n<p>Table to check: computers<br>Field to Check: LastContact<br>Check Condition: GreaterThan<br>Result: DATE_ADD(NOW(), INTERVAL -6 MONTH)<br>Identity Field: computers.name<br>Additional Condition: computers.computerid in(select computerid from computerconfig where computerconfig.heartbeatenable=1) AND computers.computerid in(Select computerid from computers where computers.lastcontact &lt; (date_add(now(),interval -3 MONTH)))<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Interval: 6 HoursSend Fail After Success Table to check: computersField to Check: LastContactCheck Condition: GreaterThanResult: DATE_ADD(NOW(), INTERVAL -6 MONTH)Identity Field: computers.nameAdditional Condition: computers.computerid in(select computerid from computerconfig [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8371","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=8371"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8371\/revisions"}],"predecessor-version":[{"id":8372,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8371\/revisions\/8372"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=8371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=8371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=8371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}