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 firstname.lastname@example.org, email@example.com' where email like '%OldEmail@gregsowell.com%';
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.