Why would my OPC tag with history enabled get a sample every second if the value doesn't change?
As long as I don't have Max Time Between Samples configured, I would not expect multiple samples with the same value. Is there anything I am missing? The table is populated with As Stored so there is not interpolation...
I think you do have Max Time Between Samples configured. A value of zero is not "not configured". You've told it zero delay - so record the tag value at the polling rate, which I assume is default and set to 1000 ms. [This is incorrect. See Chris_Bingham's docs reference in post #5 below.]
Instead change it to a value that ensures you get at least one reading in every period of likely interest. This will avoid problems when you select a timespan when no changes were recorded.
You were both right. I didn't realize 0 does not mean "nothing" in Max Time Between Sample. And this was basically choking the OPC which kept changing quality from Good to Good Overload, and this also explains what Steve mentioned.
It seems to be good now and I took Transistor's advice to have a Max time also to guarantee some data in the historian...
No problem. I still like your recommendation to set a reasonable value. 1/hour, 1/day…whatever makes sense to collect “as little data as possible for that point, but no less…”
I suspect that @Steve_Laubach was correct, in that tag quality might be contributing excess data.
Though, perhaps data type is a float, we’re not seeing the truncated data (additional decimal places), and compression settings (absolute @ 0.01) are working as expected?
The type is integer and I moved them all to 10 sec poll rate and now they are always GOOD and not repeating values. I think root cause was quality status changing, I saw an older post