Enter MySQL mode:
mysql -u$(grep "^DBUser" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//") -p$(grep "^DBPassword" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//")
List everything that has something in value_str:
select * from zabbix.profiles where userid=1 and value_str<>'';
Result:
MariaDB [zabbix]> select * from zabbix.profiles where userid=1 and value_str<>'';
+-----------+--------+--------------------------------------+-------+----------+-----------+---------------------+--------+------+
| profileid | userid | idx | idx2 | value_id | value_int | value_str | source | type |
+-----------+--------+--------------------------------------+-------+----------+-----------+---------------------+--------+------+
| 3 | 1 | web.dashbrd.stime | 1 | 0 | 0 | 20180421152954 | | 3 |
| 5 | 1 | web.menu.config.last | 0 | 0 | 0 | hosts.php | | 3 |
| 8 | 1 | web.hosts.php.sort | 0 | 0 | 0 | name | | 3 |
| 9 | 1 | web.hosts.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 10 | 1 | web.paging.lastpage | 0 | 0 | 0 | latest.php | | 3 |
| 11 | 1 | web.menu.view.last | 0 | 0 | 0 | latest.php | | 3 |
| 12 | 1 | web.latest.php.sort | 0 | 0 | 0 | name | | 3 |
| 13 | 1 | web.latest.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 14 | 1 | web.proxies.php.sort | 0 | 0 | 0 | host | | 3 |
| 15 | 1 | web.proxies.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 16 | 1 | web.menu.admin.last | 0 | 0 | 0 | adm.gui.php | | 3 |
| 618 | 1 | web.scripts.php.sort | 0 | 0 | 0 | name | | 3 |
| 619 | 1 | web.scripts.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 621 | 1 | web.templates.php.sort | 0 | 0 | 0 | name | | 3 |
| 622 | 1 | web.templates.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 624 | 1 | web.templates.filter_name | 0 | 0 | 0 | dhcp | | 3 |
| 627 | 1 | web.graphs.php.sort | 0 | 0 | 0 | name | | 3 |
| 628 | 1 | web.graphs.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 661 | 1 | web.items.php.sort | 0 | 0 | 0 | name | | 3 |
| 662 | 1 | web.items.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 663 | 1 | web.latest.filter.select | 0 | 0 | 0 | Device | | 3 |
| 669 | 1 | web.item.graph.stime | 59639 | 0 | 0 | 20180416184139 | | 3 |
| 671 | 1 | web.correlation.php.sort | 0 | 0 | 0 | name | | 3 |
| 672 | 1 | web.correlation.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 674 | 1 | web.item.graph.stime | 28786 | 0 | 0 | 20180417100003 | | 3 |
| 676 | 1 | web.menu.cm.last | 0 | 0 | 0 | hostinventories.php | | 3 |
| 677 | 1 | web.hostinventories.php.sort | 0 | 0 | 0 | name | | 3 |
| 678 | 1 | web.hostinventories.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 679 | 1 | web.triggers.php.sort | 0 | 0 | 0 | description | | 3 |
| 680 | 1 | web.triggers.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 686 | 1 | web.host_discovery.php.sort | 0 | 0 | 0 | name | | 3 |
| 687 | 1 | web.host_discovery.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 688 | 1 | web.disc_prototypes.php.sort | 0 | 0 | 0 | name | | 3 |
| 689 | 1 | web.disc_prototypes.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 690 | 1 | web.trigger_prototypes.php.sort | 0 | 0 | 0 | description | | 3 |
| 691 | 1 | web.trigger_prototypes.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 693 | 1 | web.screenconf.php.sort | 0 | 0 | 0 | name | | 3 |
| 694 | 1 | web.screenconf.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 695 | 1 | web.applications.php.sort | 0 | 0 | 0 | name | | 3 |
| 696 | 1 | web.applications.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 698 | 1 | web.menu.reports.last | 0 | 0 | 0 | toptriggers.php | | 3 |
| 699 | 1 | web.auditlogs.filter.alias | 0 | 0 | 0 | Admin | | 3 |
| 703 | 1 | web.item.graph.stime | 64632 | 0 | 0 | 20180420151019 | | 3 |
| 706 | 1 | web.httpconf.php.sort | 0 | 0 | 0 | name | | 3 |
| 707 | 1 | web.httpconf.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 709 | 1 | web.hostgroups.php.sort | 0 | 0 | 0 | name | | 3 |
| 710 | 1 | web.hostgroups.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
| 713 | 1 | web.discoveryconf.php.sort | 0 | 0 | 0 | name | | 3 |
| 714 | 1 | web.discoveryconf.php.sortorder | 0 | 0 | 0 | ASC | | 3 |
+-----------+--------+--------------------------------------+-------+----------+-----------+---------------------+--------+------+
Solution:
delete from zabbix.profiles where profileid=663;
Query web.latest.filter.application:
select * from zabbix.profiles where userid=1 and value_str<>'' and idx='web.latest.filter.application';
No comments:
Post a Comment