hi all,
I have a little bit of a noob quiestion, it's more database related then zabbix really but one has to understand the zabbix structure in order to be able to awnser my question.
I would like to list all offline proxy's. but only the offline proxy's trough a direct mariadb sql statement.
I was able to create this:
select * from hosts where hosts.name like '%zabbix%' and hosts.name not like '%template%'
(Note: all my zabbix proxy's hava a host name with zabbix, therefore my query does list all my proxy's)
But now do I get the offline proxy's?
thank you very mutch for your help!
I have a little bit of a noob quiestion, it's more database related then zabbix really but one has to understand the zabbix structure in order to be able to awnser my question.
I would like to list all offline proxy's. but only the offline proxy's trough a direct mariadb sql statement.
I was able to create this:
select * from hosts where hosts.name like '%zabbix%' and hosts.name not like '%template%'
(Note: all my zabbix proxy's hava a host name with zabbix, therefore my query does list all my proxy's)
But now do I get the offline proxy's?
thank you very mutch for your help!