Where is the status of the zabbix trigger stored? That is, information about whether it works or not. I thought that the status field in the database is responsible for the state of the network node, but as it turned out, it is not. Please tell me which way to dig.

The documentation says that the active parameter of the trigger.get method returns all active triggers. But in my form of an array, information about all the triggers is returned, and there is no such element that would be responsible for their states.

    1 answer 1

     SELECT groups.name, hosts.hostid, hosts.host, triggers.description, triggers.comments, triggers.triggerid, triggers.priority FROM triggers INNER JOIN functions ON triggers.triggerid=functions.triggerid INNER JOIN items ON items.itemid=functions.itemid INNER JOIN hosts ON hosts.hostid=items.hostid INNER JOIN hosts_groups ON hosts_groups.hostid=hosts.hostid INNER JOIN groups ON groups.groupid=hosts_groups.groupid WHERE hosts.status = 0 AND items.status = 0 AND triggers.status = 0 AND triggers.value=1;