Update Cacti Syslog Alert Emails In Bulk

While cactiEZ does make some things easy, editing the syslog alerts in bulk isn’t one of them. To do it quickly, simply do the following from the Mysql CLI:

1
2
3

update syslog_alert 
set email='[email protected], [email protected]' 
where email like '%[email protected]%';

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.
In the where clause, change whatever needs to be matched in between the %. The percent sign is a wildcard.

Have fun folks.