GS gregsowell.com Inside Greg’s Brain

Modify Cacti Alerts In Mass

April 10, 2013

So I’m updating syslog and thold alerts in mass…removing an email address actually. Here are a couple of quick find and replace statements:

Syslog Alerts

use syslog;
update syslog_alert set email=replace(email,', [email protected]','');

Thold Alerts

use cacti;
update cacti set thold_data=replace(notify_extra,'[email protected], ','');

Comments

2 responses to “Modify Cacti Alerts In Mass”

April 18, 2013

Grega

Hi Greg,

This is just a general question regarding Cacti. Do you still prefer it over alternatives like Zabbix? Why?
April 18, 2013

Greg

@Grega
I’ve not explored other systems for so long, that I’ve just stuck with Cacti because it works. If I had enough free time to test I might move. I’ve heard good things about Zabbix.

Leave a Reply