[Imported] Generate Reports of system changes SQL Export

[sbeadle]

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

[sbeadle · Accepted solution]

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