[Imported] User report

[sbeadle]

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

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

**_FatemehMot:_**
**_Hi,_**
**_In my project , I want know which user changed the value of a point )with a query)_**
**_Could you please help me?_**

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

dmercer:
Control actions are normally stored in the event journal. Which contains all of this:

 ah/925kbdd34mxz.jpg "")

This query should get you started:
SELECT Id, RecordTime, Message, User, Category

FROM CDBEventJournal

WHERE "RecordTime" {OPC 'H'} AND Category = 'Action'

Attached file: (editor/ah/925kbdd34mxz.jpg), Capture.JPG File size: 628102