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

Revisions

  1. FilBot3 revised this gist Nov 14, 2015. 2 changed files with 6 additions and 6 deletions.
    4 changes: 2 additions & 2 deletions zabbix_proxy_fixit.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    USE zabbix_proxy;

    truncate table proxy_history;
    delete from ids;
    TRUNCATE TABLE proxy_history;
    DELETE FROM ids;

    8 changes: 4 additions & 4 deletions zabbix_server_fixit.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,7 +1,7 @@
    USE zabbix;

    delete from escalations;
    update alerts set status=1 where status=0;
    DELETE FROM escalations;
    UPDATE alerts SET status=1 WHERE status=0;

    select count(*) from escalations;
    select count(*) from alerts where status=0;
    SELECT count(*) FROM escalations;
    SELECT count(*) FROM alerts WHERE status=0;
  2. FilBot3 created this gist Nov 14, 2015.
    5 changes: 5 additions & 0 deletions zabbix_proxy_fixit.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    USE zabbix_proxy;

    truncate table proxy_history;
    delete from ids;

    7 changes: 7 additions & 0 deletions zabbix_server_fixit.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    USE zabbix;

    delete from escalations;
    update alerts set status=1 where status=0;

    select count(*) from escalations;
    select count(*) from alerts where status=0;