{"id":5256,"date":"2016-05-13T13:16:12","date_gmt":"2016-05-13T19:16:12","guid":{"rendered":"http:\/\/gregsowell.com\/?p=5256"},"modified":"2016-05-13T13:16:12","modified_gmt":"2016-05-13T19:16:12","slug":"update-cacti-syslog-alert-emails-in-bulk","status":"publish","type":"post","link":"https:\/\/gregsowell.com\/?p=5256","title":{"rendered":"Update Cacti Syslog Alert Emails In Bulk"},"content":{"rendered":"<p>While cactiEZ does make some things easy, editing the syslog alerts in bulk isn&#8217;t one of them.  To do it quickly, simply do the following from the Mysql CLI:<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">update syslog_alert \r\nset email=&#039;me@gregsowell.com, you@gregsowell.com&#039; \r\nwhere email like &#039;%OldEmail@gregsowell.com%&#039;;<\/code><\/pre>\n<p>The set command will replace the email field with whatever is entered between the single quotes.  Be sure to use a comma and space between email addresses.<br \/>\nIn the where clause, change whatever needs to be matched in between the %.  The percent sign is a wildcard.<\/p>\n<p>Have fun folks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While cactiEZ does make some things easy, editing the syslog alerts in bulk isn&#8217;t one of them. To do it quickly, simply do the\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5256","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/5256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5256"}],"version-history":[{"count":1,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/5256\/revisions"}],"predecessor-version":[{"id":5258,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/5256\/revisions\/5258"}],"wp:attachment":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}