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
84611members
353911posts

[Imported] Develop Tool - Display Reference to Decommissioned Points

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
282

[Imported] Develop Tool - Display Reference to Decommissioned Points

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-19 20:02:52 Id:163
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

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

**_NIWTelemetry:
Hello Everyone. Looking for some ideas.
I have a series of mimics containing network schematics with embedded flow values / SR levels - referenced from live analogue points on the database.
We are involved with a large outstation replacement project which involves decommissioning old Proteus analogue points and replacing them with new WITS analogue points.
A number of schematics have been found to reference decommissioned analogue points and need to be updated to reference the new analogue point.
My question is - is there anyway a script can be written to find and report any references to decommisioned points - in order to help keep the schematics up to date?
Thanks in advance - open to any ideas._**

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

elfstyle:
Hi! You can use my tool for this job
[http://se-scada.net/forum/discussion/157/automation-in-creating-instances-of-the-clearscada-template... "http://se-scada.net/forum/discussion/157/automation-in-creating-instances-of-the-clearscada-template...")
Also I made a short video for you where I'm searching for references of Internal Analogue Point.
[https://youtu.be/zvqwA_VsS0U](https://youtu.be/zvqwA_VsS0U "https://youtu.be/zvqwA_VsS0U")
I don't have proteus objects in my tool, but i think we can figure out something.

________________

**_NIWTelemetry:
Thanks very much for the reply. I will check this out and get back to you._**

______

dmercer:
This sometimes also be done using export/import tricks.

You can export a mimic or group, remove or rename the old points, put the new points in with the same FullNames as the old points, and reimport the mimic. It often requires shuffling large number of objects though, which can take the database a long time to do. It's not always practical.

_________

sbeadle:
There are .Net client API methods 'getReferencesFrom' and 'getReferencesTo' which will do the same as the client's 'get references' menu. Just open a connection, get an object by name and call the method.

__________

**_NIWTelemetry:
Hi Dean thanks for your thoughts. Unfortunately the group which contains the mimics and schematics is in a separate area of the database from another parent folder which potentially would contained a referenced decommissioned point which would make this difficult._**

_____________

hardin4019:
First thought that crossed my mind was to build a query something like this, though not tested or exactly what you might be looking for. See if this gives you a "referenced from" column and move forward from there.

_Select
*
From
CDBPoint
Where
Inservice Like False AND PointType Like Proteus, and TemplateID Not Like -1_