find all hosts that have no action defined

[tvtue]

Hello,

it should be possible to formulate a SQL statement which lists all hosts, that have no action defined for them. If working together with multiple admins, it would be nice to tell them where they missed something.

I took a look into the tables, but I haven't found the glue between hosts, triggers and actions so far.

This gives all hosts, that are of interest:

SELECT host,status FROM hosts WHERE status=0;

and these are all actions:

SELECT actionid,name FROM actions WHERE eventsource=0 AND status=0;

Maybe someone has done this before and can help me?

We are using Zabbix 2.0.x with postgres.

thx and regards,
tvtue

[Heilig]

I took a look into the tables, but I haven't found the glue between hosts, triggers and actions so far.

Perhaps, you be able to find the glue here.

[tvtue]

Hello Heilig,

thank you for that link. I haven't found the time to digg deeper into that yet. But will have a look.

tvtue.

[Heilig]

In this situation, is more correct to use the API. See method action.get (https://www.zabbix.com/documentation...api/action/get) and action.exists (https://www.zabbix.com/documentation.../action/exists), perhaps you don't need glue.