template table

[Pablo]

Hello,
I'm looking for the relationship between triggers and hosts. I think, I can do it through functions table, but I have a doubt with templates. I don´t find the template table but I find many index templateid in other tables. Are there the template table?, have I use it to relationship hots and triggers?.

Thnaks
Pablo

[James Wells]

Greetings,

Hello,
I'm looking for the relationship between triggers and hosts. I think, I can do it through functions table, but I have a doubt with templates. I don´t find the template table but I find many index templateid in other tables. Are there the template table?, have I use it to relationship hots and triggers?.

I am not sure what you are asking, but I suspect you asking how to trace a trigger through templates to host / items. When you look at the database, you will find that triggers get "imploded" down to something like the following;

{3214}>75

The numeric value '3214' is actually the functionid from the functions table, Additionally, in the functions table, there is a link to the items table, via the itemid. Each item in the items table, has a link to the hosts table, via the hostid field, but also to the template host through the templateid field. With the hostid field, you can find the host that the trigger is attached to, and the template that the host inherits it's templates from.

In addition to the above, please remember that templates are hosts, that are not monitored. Each template has items associated with it via the items table, using the hostid. From there, you just follow the item back to the functions table. And in the function table, there is also a pointer back to the trigger table via the triggerid field.

I hope that wasn't too confusing.