I am currently using the following to get back a list of discovery errors and unsupported items in 3.4.11
mysql --skip-column-names zabbix -e "select host, items.name,items.description from hosts inner join items on items.hostid = hosts.hostid where items.error != '' INTO OUTFILE '/mnt/DB/mysql/zabbix_errors.txt' FIELDS TERMINATED BY '\,' "
However I want it to ignore any items that are set to disabled.
Anyone know what the sql syntax would be ?
Thanks
Simon
mysql --skip-column-names zabbix -e "select host, items.name,items.description from hosts inner join items on items.hostid = hosts.hostid where items.error != '' INTO OUTFILE '/mnt/DB/mysql/zabbix_errors.txt' FIELDS TERMINATED BY '\,' "
However I want it to ignore any items that are set to disabled.
Anyone know what the sql syntax would be ?
Thanks
Simon