• Replies 2 replies
  • Subscribers 581 subscribers
  • Views 199 views
  • Users 0 members are here
Options
Related

Operator Actions in SQL Database

StolzEnter

Hello,

I am trying to store operator actions in SQL database by assigning LOG Device in devices as SQL.

I am succeeded to log it in TEXT file as log device.
My query is.

1.How to configure SQL for this.I have created SQL Database 

2.What is the scripting part for logging in SQL ?

Or is any other way to do this..

Thanks.

Parents
  • It is very well possible to configure a device in Citect for basic logging to SQL. Please refer to the Citect help on topics "Configuring SQL Devices" and "Object Properties - Input (Keyboard Commands".
    Here, the configuration of the device for logging is explained as well as how to use the device in cicode scripts additionally.
    Make sure you include the following fields in your device format as well as in your SQL table (as varchar columns):
    {MsgLog,32} and {FullName,15}
Reply
  • It is very well possible to configure a device in Citect for basic logging to SQL. Please refer to the Citect help on topics "Configuring SQL Devices" and "Object Properties - Input (Keyboard Commands".
    Here, the configuration of the device for logging is explained as well as how to use the device in cicode scripts additionally.
    Make sure you include the following fields in your device format as well as in your SQL table (as varchar columns):
    {MsgLog,32} and {FullName,15}
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.