Hi,
i would like to query the database to find items who belong to a specific template AND have a "non supported" state.
This query report too much results. All items are return, not only items at the mysql template.
select host,items.name,items.error from hosts inner join items on items.hostid = hosts.hostid where items.error = 'ZBX_NOTSUPPORTED' and hosts.host in (select distinct(h_host.host) from hosts_templates ht, hosts h_host, hosts h_template where ht.hostid = h_host.hostid and ht.templateid = h_template.hostid and h_host.status !=3 and h_template.host like '%mysql%');
Thanks for you help
i would like to query the database to find items who belong to a specific template AND have a "non supported" state.
This query report too much results. All items are return, not only items at the mysql template.
select host,items.name,items.error from hosts inner join items on items.hostid = hosts.hostid where items.error = 'ZBX_NOTSUPPORTED' and hosts.host in (select distinct(h_host.host) from hosts_templates ht, hosts h_host, hosts h_template where ht.hostid = h_host.hostid and ht.templateid = h_template.hostid and h_host.status !=3 and h_template.host like '%mysql%');
Thanks for you help