Make the most of your remote operations with end-to-end solutions with Process Automation’s SCADA and Telemetry Solutions. With the challenges that remote sites present, reliable communications for remote operation, monitoring & management are vital in enhancing productivity and ensuring profitability.
>>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?
Re: [Imported] Historic Events over the past 24 Hours
>>Responses imported from previous forum
Reply From 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?).