I'm looking to see if there are any tools that can "skinny" down historical data. We are now supporting some hosts that had overly high poll rates when they were commissioned, the historian subsequently got bloated and is now using up too much HDD space.
Are there any tools available that can go back and remove swaths of data, or perhaps replace a 10 min span of 1 second data with a single average or something like that?
Most of the data isn't needed as the deadband was also too small. We could set the historian purge value to 365 days or something and let the old data fall off, but that wouldn't be ideal. There are thousands or tens of thousands of tags in these systems, so a manual process would be a bit prohibitive as well.
Any suggestions are appreciated. Thanks.