[zabbix DB] relation between templates and his graphs ?

[Eddriks]

Hello everybody

i'm looking for a while to find a relation in the zabbix DB between templates and his graphs.

I would like to have the list of graphs who belong to one templates with one sql query.

I've already look the db severals time but i've not find any solution to get this =/


Someone have any idea ?


thanks a lot .

[sarathyme]

please see if this helps.

SELECT DISTINCT h.host, g.name 
FROM   hosts h, 
       graphs g, 
       graphs_items gi, 
       items i 
WHERE  h.hostid = i.hostid 
       AND gi.graphid = g.graphid 
       AND gi.itemid = i.itemid 
       AND h.status = 3  order by h.hostid;

Here h.status=3 is to select only templates. If you wanted for both hosts and templates take that codition out.

Status
0-Host Monitored
1-Not Monitored
3-Template
5-Proxy hosts

Regards
Vijay

[Eddriks]

Niceee !!!

it's absolutely that I want! .

you're awesome !


thanks a lot !