Aggregate Graph Data

[jyork1107]

Hello,

New to using rrd tools and Cacti, please bear with me.

I'm trying to pull down data from an aggregate graph in a python script using <rrdtools fetch> but cannot locate the agg graphs associated rrd file on the server.

Anyone here know why?

Thanks,
Josh

[TheWitness]

Look at the table:

Code: Select all

MariaDB [cacti]> desc aggregate_graphs_items;
+--------------------+-----------------------+------+-----+---------+-------+
| Field              | Type                  | Null | Key | Default | Extra |
+--------------------+-----------------------+------+-----+---------+-------+
| aggregate_graph_id | int(10) unsigned      | NO   | PRI | NULL    |       |
| local_graph_id     | int(10) unsigned      | NO   | PRI | NULL    |       |
| sequence           | mediumint(8) unsigned | NO   |     | 0       |       |
+--------------------+-----------------------+------+-----+---------+-------+
3 rows in set (0.001 sec)

You then have to get yourself to the local_data_id which is a join between two more tables. Then you can get to the RRDfiles

Code: Select all

SELECT DISTINCT rrd_path
FROM poller_item AS pi
INNER JOIN data_template_rrd AS dtr
ON pi.local_data_id = dtr.local_data_id
INNER JOIN graph_templates_item AS gti
ON gti.task_item_id = dtr.id
INNER JOIN aggregate_graphs_items AS agi
ON agi.local_graph_id = gti.local_graph_id
WHERE aggregate_graph_id = X;

Something like that.

[jyork1107]

Thank you. This might not work for what Im trying to achieve. The aggregate graph polls 6 rrds every 5min then adds them up to get total max bandwidth across all our circuits in that 5min interval. The graph then finds the MAX of the aggregate bandwidth totals at the end of day. This MAX total is what Im trying to extract from the aggregate graph.

Thanks again for your in depth post.