Help on Cimplicity 8.2 Historical Alarm Viewer

[demitriuss 0]

Hi, guys.

I am struggling to develop a solution for a costumer in a Historical Alarm Viewer screen, I am new to Cimplicity and to database supervisory interface. Among other things, the customer is asking to:

- Change the "A"; "R"; "G"; "N" notations under "log_action" column to somenthing more intuitive for the users (operation). Please have a look at the image "image.jpg";

-Change the point manager process "MASTER_PTMR0_RP" log under "logged_by" column to the user that is currently logged in. Specificaly saying, when I send a command (changing a setpoint or issue a reset command, for example), although it is the user acting, the historical alarm viewer logs the action as "MASTER_PTMR_RP". I Imagine that is because this process is reponsable for exchange point data to/from the IHM points database, but it is still essential to the system administrator to know which user sent that reset command or changed the variable setpoint.The log inputs at the image "image.jpg" has boolean and integer commands (".CXX" sufix);

-Log into the historical alarm viewer if the user logs out and what user logged in.

It is valid to mention that I am using the ALARM_LOG table (apparently it is the only table working with the application, DATA_LOG, EM_LOG and the others simply do not work, they don't show any column at all, honestly I don't know why).

I tried to use Microsoft SQL Server Management Studio to edit the table information, but, somehow, it seems to be blocked to edition.

I imagine they are some specific configurations, but I have no idea on how to acomplish them. Maybe if I could use other tables would fulfill the requirements, but , like I said, they are not working (right now I am trying to re-configure the Database Logger from the beggingin to see if it works with other tables).

If you could give me some inisights on how to change these settings I would be very grateful. I will be happy to give more information if needed.

Thanks in advance.