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
84650members
353990posts

[Imported] Generate Reports of system changes SQL Export

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
371

[Imported] Generate Reports of system changes SQL Export

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: ROVSCADAENGINEER, originally posted: 2019-04-16 03:08:13 Id:407
I am wanting to generate reports of system changes with an SQL export done at timely intervals.

I am wondering which schema to query.

I understand that SCADA has an option where you can see all the "property changes" made on the system for a server. However when you observe this list I am unaware of anyway to see which schema class this is coming from. Does anyone have any idea how I might do this?


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
369

Re: [Imported] Generate Reports of system changes SQL Export

>>Responses imported from previous forum


Reply From User: dmercer, posted: 2019-04-16 05:46:07
In ClearSCADA lists, you can right click and then click on Edit Query to see what query it uses. In this case the default for property changes is:

`SELECT TOP( 1000000 )
"RecordId", "RecordTime", "ObjectName", "FieldName", "OldValue", "NewValue", "User", "OriginDesc"
FROM
CDBCONFIGCHANGES
WHERE
( "RecordTime" BETWEEN { OPC 'H-23H' } AND { OPC 'H+1H' } )
ORDER BY
"RecordTime" DESC`


Reply From User: ROVSCADAENGINEER, posted: 2019-04-16 21:27:15
That's extremely useful to know dean. Thankyou very much!

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
370

Re: [Imported] Generate Reports of system changes SQL Export

>>Responses imported from previous forum


Reply From User: dmercer, posted: 2019-04-16 05:46:07
In ClearSCADA lists, you can right click and then click on Edit Query to see what query it uses. In this case the default for property changes is:

`SELECT TOP( 1000000 )
"RecordId", "RecordTime", "ObjectName", "FieldName", "OldValue", "NewValue", "User", "OriginDesc"
FROM
CDBCONFIGCHANGES
WHERE
( "RecordTime" BETWEEN { OPC 'H-23H' } AND { OPC 'H+1H' } )
ORDER BY
"RecordTime" DESC`


Reply From User: ROVSCADAENGINEER, posted: 2019-04-16 21:27:15
That's extremely useful to know dean. Thankyou very much!