{"id":9372,"date":"2025-12-01T02:05:05","date_gmt":"2025-12-01T02:05:05","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=9372"},"modified":"2025-12-01T02:05:06","modified_gmt":"2025-12-01T02:05:06","slug":"labtech-automate-event-log-internal-monitor","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/labtech-automate-event-log-internal-monitor","title":{"rendered":"Labtech Automate Event Log Internal Monitor"},"content":{"rendered":"\n<p><strong>Identity Field<\/strong><\/p>\n\n\n\n<p>substr(concat(eventlogs.logname,&#8217; &#8216;, eventlogs.eventid,&#8217; &#8211; &#8216;, replace(replace(replace(replace(replace(replace(eventlogs.message,&#8217;\\&#8221;, &#8221;),&#8217;\\&#8221;&#8216;, &#8221;),&#8217;\\&#8217;, &#8221;), &#8216;\\t&#8217;, &#8221;), &#8216;\\r&#8217;, &#8221;), &#8216;\\n&#8217;, &#8221;)), 1, 150)<\/p>\n\n\n\n<p><strong>Additional Condition<\/strong><\/p>\n\n\n\n<p>(eventlogs.<code>Source<\/code> = &#8216;MSSQLServer&#8217; or eventlogs.<code>Source<\/code> = &#8216;sqlserveragent&#8217;) and eventlogs.<code>EventID<\/code> in (&#8216;3041&#8242;,&#8217;208&#8242;,&#8217;18210&#8217;) and eventlogs.<code>EventType<\/code> &lt;> &#8216;2&#8217; and timegen > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"239\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image-1024x239.png\" alt=\"\" class=\"wp-image-9373 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image-1024x239.png 1024w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image-300x70.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image-768x179.png 768w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/12\/image.png 1511w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Identity Field substr(concat(eventlogs.logname,&#8217; &#8216;, eventlogs.eventid,&#8217; &#8211; &#8216;, replace(replace(replace(replace(replace(replace(eventlogs.message,&#8217;\\&#8221;, &#8221;),&#8217;\\&#8221;&#8216;, &#8221;),&#8217;\\&#8217;, &#8221;), &#8216;\\t&#8217;, &#8221;), &#8216;\\r&#8217;, &#8221;), &#8216;\\n&#8217;, &#8221;)), 1, 150) Additional Condition (eventlogs.Source = &#8216;MSSQLServer&#8217; or eventlogs.Source = [&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-9372","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/9372","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=9372"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/9372\/revisions"}],"predecessor-version":[{"id":9374,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/9372\/revisions\/9374"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=9372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=9372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=9372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}