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
84248members
353348posts

[Imported] Database optimisation tool

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.

sbeadle
Janeway Janeway
Janeway
0 Likes
0
296

[Imported] Database optimisation tool

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: florian, originally posted: 2018-10-25 20:22:58 Id:304
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

-------------------------------

**_shump:_**
**_We use the database optimisation tool that is in-built into ClearSCADA. So we use it driven froma periodic script, specifying a start and end date. For now, we run it daily, to look back for the last 2 days. This does resolve or delete many duplicates, out of time order entries; we find the tool VERY useful. I realise I could run it manually when I want, using whatever time period I desire. But a couple of improvements could be made, I suggest:_**

**_a) Run it from a command line perhaps, with some flags, in case I do not want it to action some issues it finds immediately:_**

**_b) Add some flags, say:_**

**_i) -i - information mode: to just list what it is going to change, detailed for each record_**

**_ii) -s - summary mode: a high level summary (number of records deleted or resorted, and why etc.)_**

**_iii) -o - to send the output to a file rather than the command line_**

**_Just my 2c worth._**

**_cheers, Scott_**

---------------------

JesseChamberlain:
Scott, you can run it from command line, have a look at SCXCMD HISINFO and HISSTRIP. Reference here.

https://tprojects.schneider-electric.com/telemetry/display/public/CS/ClearSCADA+Command+Line+Utility

---------------


**_shump:_**
**_Thanks Jesse - I will give it a try._**