Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84614members
353913posts

[Imported] Historic Events over the past 24 Hours

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
467

[Imported] Historic Events over the past 24 Hours

>>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


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
466

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?).

Longer term...

1. Check out https://tprojects.schneider-electric.com/telemetry/display/CS/Finding+large+historic+granules, just note that historic granules are weekly based not daily based
2. Recent versions of ClearSCADA have config on the root group to define warning alarms and max values for historic storage, check those out to see if they could be of help

 


Reply From User: KKOKLEBECK, posted: 2019-06-26 19:17:01
Thanks for the feedback. We have found a very large offender at a new location.


Reply From User: sbeadle, posted: 2019-06-27 12:24:43
Super. A quick way of doing this is to use ViewX and execute this:
select id,fullname,typename,processcount from cdbpoint order by id

Do it twice with a 1 hour or 30 min interval between each.
Then copy data in both instances to Excel getting the differences.

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
467

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?).

Longer term...

1. Check out https://tprojects.schneider-electric.com/telemetry/display/CS/Finding+large+historic+granules, just note that historic granules are weekly based not daily based
2. Recent versions of ClearSCADA have config on the root group to define warning alarms and max values for historic storage, check those out to see if they could be of help

 


Reply From User: KKOKLEBECK, posted: 2019-06-26 19:17:01
Thanks for the feedback. We have found a very large offender at a new location.


Reply From User: sbeadle, posted: 2019-06-27 12:24:43
Super. A quick way of doing this is to use ViewX and execute this:
select id,fullname,typename,processcount from cdbpoint order by id

Do it twice with a 1 hour or 30 min interval between each.
Then copy data in both instances to Excel getting the differences.