Historical Data Archiving....

[Guest]

Guys,

Must say i love cacti but I am fighting a battle at the moment that I have someone can help me with....

Basically, I need to archive the data for a whole month, ie, with zero summaries and grouping...

Why, we do some post month analysis of peaks etc etc for bandwidth management...

Now with mrtg, it was easy, as we had all 'in' point and all 'out' points in the one graph cfg there was one log file for this data, once a night we ran some perl over it and the files was archived. Then at the end of the month we chomped all the files together and we had a "report" made up of peaks and low points for the month...

Now, cacti/rrdtool make life a little harder, while my graph is made up of multiple "data sources" 8, to be exact, the graph works fine... what i am trying to do to complete my other requirement is this.

(ill just lay out what im trying to do here)

graph - point 1
- point 2
- point 3

find the "filenames" of the files used in this graphs data point, because ill then rrdtool dump $filename and grep for the timestamp and in/out data and then insert it into a db table for grouping at a later date.

what i need is a way each night of running a query on the database from the command line that based on a graphs title, ie "[inbound] egress" pulls the filenames of all the rra sources needed to generate this graph... once i have this i can shell script the rest up...

however, im stuck, I can work out from where I retrieve the "file information" ie, the name of the files that make up the data source within the graph....


any help would be appreciated, if you dont understand what im trying to do, let me know, ill try to explain it better....

[nyx_au]

sorry ... i posted this... thought I was logged in!!!