Can someone please post a sample SQL command that will purge extreme values from a datapoint, or purge values within a certain time range?

I realize that I can set a discard low/high limit, but that does not help once the data is already logged. I have often found that when adjusting metadata formulas I sometimes wind up with a recent datapoint value that screws up my dataset, and consequently the graph scaling. My other option is the purge function, but that would cause me to lose all history before that point.

It would also be useful to know how to replace point values that meet a certain date or value threshold. This would enable me to, for instance, change the scaling of prerecorded datapoints. e.g. to replace a Fahrenheit temperature dataset history with a Celsius dataset, or replace amperes with milliamperes.

Thanks

How much memory does your host system have? You can adjust the maximum heap size of your instance with options such as -Xmx. (Which you can set in your Tomcat start scripts. Look for the JAVA_OPTS setting.)

I believe the default max heap size in Java is 64MB. If you wanted to change this to 256MB, you would add the option "-Xmx256M".

I meant to post a reply earlier but I forgot. I rebooted the server and it went away. It must have been some kind of persistent little fluke because I had tried that already.

Hi Josh,

No, there is currently no way to "lock" a chart open. Interesting idea though..

UPDATE!

After working for some long hours with the mfg :(, I determined that it might work better if I use SNMP....

Success!!! :D

In about 10 minutes I had the whole thing working better than our current software! I'll be playing with it over the weekend and most likely complete the conversion to this next week.

I do have another question, but I think it might belong in another category or at least it's own thread.
Thanks again for all the help!