|
|
| Author |
Message |
pgb205
Joined: 10 Nov 2008 Posts: 17
|
Posted: Tue Nov 11, 2008 8:29 pm Post subject: Recording Historical Data Possible?? |
|
|
so that every time poller polls devices on my network all the information retrieved would be recorded to mysql database. So for example if I'm monitoring interface for traffic, every time the OID is polled, that informaiton would be inserted into a table in mysql with time stamp and UID of the interface. This way I can retrieve this information later for graphing purposes etc. Is this possible? Or maybe it's already done in cacti, but I can't find the table which has this data.
thanks |
|
| Back to top |
|
 |
gandalf Developer
Joined: 02 Dec 2004 Posts: 12642 Location: Muenster, Germany
|
Posted: Wed Nov 12, 2008 3:53 pm Post subject: |
|
|
This is done using table poller_output. On each polling circle, this table is filled with data. Then, the data is updated into rrd files (that's why cacti is an rrdtool frontend) and deleted from that table.
You may want to intercept this step, but this is definitively a user mod.
You may want to consult 1st link of my sig to understand cacti's principles of operation
Reinhard |
|
| Back to top |
|
 |
pgb205
Joined: 10 Nov 2008 Posts: 17
|
Posted: Thu Nov 13, 2008 9:50 am Post subject: |
|
|
yep thats what i did. created a new table called historical. and every time cmd.php writes to pollet_output i also modified it to db_execute to historical.
now a simple matter of manipulating this information with sql.
thanks |
|
| Back to top |
|
 |
|