>>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?
Solved! Go to 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!
>>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!
User | Count |
---|---|
188 | |
52 | |
16 | |
16 | |
15 |
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!