query the cacti-database

[GamBit]

I need to query the cacti-database.

I need to find out things like that:

host-id = host = interfaces = rrd-file

I have found the table "host" in that table are the hostnames and the host-id.

Then i have found some tables with the rrd-file-names.
But in this tables there were no field with the host-id.

I can't find out the referenzes between the tables...

Can somebody help me to find out what field in of the tables ar referentes to other tables and where is what stored?

Thanx

Gambit

[raX]

Check here for a diagram of Cacti's tables and how they relate:

http://www.raxnet.net/downloads/cacti/docs/sql/

I can tell you off the top of my head that hosts are related to .rrd files by:

host.id -> data_local.host_id -> data_template_data.local_data_id

-Ian

[Guest]

hmmm, very usefull that databse outline! I hope version 0.8.2a is not going to be much different dan 0.5.8

What i'm planning to do is per leaf node in the graph tree make a global view on top of the page of which devices are OK or which devices exceed a certain value.

So i have to know which graphs (rrd files + device name and what is being monitored) are located on which tree node.

Then using the fetch function from rrdtool to get the current value and test it against a critical value.