Merge two Graphs

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
nasser
Posts: 1
Joined: Tue Apr 13, 2010 6:38 am

Merge two Graphs

Post by nasser »

Hi,
How can i merge 2 cacti graphs?
for example I have graph of device A and now I'm adding new Device B . i need to have old Device A graph as a history of device B .
is it Possible ?

Thanks in Advance
User avatar
Sirup
Cacti Moderator
Posts: 348
Joined: Tue Mar 02, 2010 9:03 am

Post by Sirup »

drewshin99
Posts: 24
Joined: Thu Jan 22, 2009 5:06 pm

data_local and graph_local

Post by drewshin99 »

i dont think the aggregate plugin would work, because the old host is going away, while adding a new one.

i think you can do something similar to what I do when we have serial port or router changes at a site and i want to keep historical data. the two tables you need to modify are data_local and graph_local.

in data_local, need to update the snmp_index of the new interface and the host id. you get the snmp_index from the "create graphs" screen under the host.

update data_local
set snmp_index="new interface snmp index"
where id="id of data source"

update data_local
set host_id="new host id"
where host_id="old host id"

then the same in graph_local
update graph_local
set snmp_index="new interface snmp index"
where id="id of data source"

update graph_local
set host_id="new host id"
where host_id="old host id"


Hopefully this works, I havent tried it this way before. However, if any data from the graph is hardcoded in the RRD file, this won't work. Except for the changes you can do through rrdtune, if any changes to the RRD file need to be made, you have to create a whole new graph.

p.s.: might also need to run the rebuild poller cache in system utilities.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests