Any way to null out some values in RRD?

[ratty]

This is a really noobish question, and I did some googling and searches here and couldn't find it.

This is most of a RRD question than cacti, but I added a switch to my cacti setup a week ago, but forgot to set it to 64-bit counters, and there are ports that push over 100mbit, so it became an issue right away. After editing the data source and fixing it, there's a huge 300gbit spike, and its going to mess up billing for my company. Is there a script that can just null those samples out? Say if sample is greater than a value, just set it to nothing.

[BSOD2600]

If you're using rrdtool 1.2 graphs, there is a tool available from here http://thetoolsmith.com/rrd_editor_index.php which claims to fix these.

Another alternative is to run rrdtool dump, manually edit the xml and remove the spike(s), then reimport it back to an rra file.

If you're still using rrdtool 1.0, then there is a removespikes.pl script that will do what you want.

[ratty]

Thanks!