Skip to content

Instantly share code, notes, and snippets.

@FilBot3

FilBot3/zabbix_proxy_fixit.sql

Last active July 4, 2018 02:43
Show Gist options
  • Save FilBot3/709f52b03a59a45f5c5c to your computer and use it in GitHub Desktop.
Save FilBot3/709f52b03a59a45f5c5c to your computer and use it in GitHub Desktop.
Download ZIP
Zabbix SQL queries to help "fix" issues
Raw
zabbix_proxy_fixit.sql
USE zabbix_proxy;
TRUNCATE TABLE proxy_history;
DELETE FROM ids;
Raw
zabbix_server_fixit.sql
USE zabbix;
DELETE FROM escalations;
UPDATE alerts SET status=1 WHERE status=0;
SELECT count(*) FROM escalations;
SELECT count(*) FROM alerts WHERE status=0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment