>>Message imported from previous forum - Category:Scripts and Tips<< User: KKOKLEBECK, originally posted: 2019-06-25 19:41:33 Id:458 All,
We are trying to determine the cause of some performance issues with our ClearSCADA system. We are using the performance stats to track events. We are having a large hit on Historical writes. We believe we have some DNP3 points that are generating a lot of data. Is there a way to view the top 100 points with the most historical writes over the past 24 hours?
Thank you, Keith
Reply User: adamwoodland, posted: 2019-06-25 22:02:21 If you need it down to the point object level then CHistory has a UpdateCount so the easiest way may be too...
1. Have a numeric data metadata field 2. Every 24 hours for the points you're interested in do a comparison between the current UpdateCount and that stored metadata field 3. Update the stored metadata field with the current UpdateCount
The first day the results won't work as the value will be 0 (can pre-seed it with the UpdateCount or change the logic to per hour instead of per-day?).