Request on the Cacti SQL database

[nicolargo]

I want to write an external script (in PHP) in order to export the graph of an existing Cacti's host. This script only knows the IP address of the host.

Do you know the SQL request to make on the CACTI SQL database in order to get the local_graph_id values from the IP address of the host ?

Thanks in advance

Nicolas

[BSOD2600]

You do realize the graph data is actually stored in the rrd files, right?

[rony]

You do realize the graph data is actually stored in the rrd files, right?

Yes, I think he knows that.

So, to clarify, you want to have a query that returns the graphs id (local_graph_id) of a particular host? Right?

That is actually a simple query... Although, I want clarification before I sit down and write it.

[nicolargo]

@rony: yes, it is exactly what i need.

Thanks in davance.

Nicolas

[smilerpt]

mysql> select graph_local.id as local_graph_id, host.id as host_id, host.hostname as hostname from (graph_local, host) where graph_local.host_id=host.id and host.hostname='127.0.0.1';
+----------------+---------+-----------+
| local_graph_id | host_id | hostname |
+----------------+---------+-----------+
| 1 | 1 | 127.0.0.1 |
| 2 | 1 | 127.0.0.1 |
| 3 | 1 | 127.0.0.1 |
| 4 | 1 | 127.0.0.1 |
| 172 | 1 | 127.0.0.1 |
+----------------+---------+-----------+
5 rows in set (0.00 sec)

Hope I got it right

rs

[nicolargo]

@smilerpt: thank you very much !