Recommended Event Log

On my vision client, I want to be able to monitor events that occur within the HMI. I have a separate screen handling all the alarms generated within the HMI, but I’d like to have another screen that will capture user actions. For example…

  1. User-Defined events:
    1. Data modified within a cell. Could be detailed to before + after data, but really just a timestamp with the action, using a script within cellEdited
    2. Button pressed that initiates a sequence
    3. User role changes
    4. etc.
  2. Machine triggered events:
    1. Sequence completion times

What type of table setup would I need to capture all of these. It would also be like writing to a console, using a system logger, but I need a friendly way for the operator, or tech support to go back through the machine history.

It is fairly typical to use a custom table with machine_id, event_id, and t_stamp columns. Perhaps also operator_id and operator_notes columns.

With joinable tables for machine information and event descriptions.

Use named queries to retrieve with suitable filters. Display in tables and with my NoteChart module on plots. (Both Vision and Reporting charts.)

/shameless plug

1 Like

I see what you did there… I will definitely research more on that NoteChart, I can think of a few uses for this alone.

So your overall suggestion is to get this data into sql and query from a main table configured for whatever information desired beyond the basic (operator id, machine id, etc.)

1 Like