Script to determine who is logged on

[jlx]

Hello, I have a remote site that is running a Geo SCADA standalone to a RTU. I also have a Enterprise SCADA running GeoSCADA. These two sites poll the same controller for DNP3 events, however the systems aren't sync'd in any way (Other than the DNP3 events being polled via radio). 

I need to know from the Enterprise SCADA who modified a setpoint or clicked a button. Only way I can think to achieve this is to create a script on the local Geo SCADA that would lookup who is logged on and update a DNP3 point based on user ID. Two questions:

Question 1: Is there a better way to sync these two SCADAs without having to write a script (Keeping in mind the Enterprise SCADA is on Radio comms)

Question 2: My script below works, however it could be better in that if users are added I would have to update the script. How do I determine who is logged on via ST, other than my current approach? 

PROGRAM ActiveUser

VAR

u01on AT %I(System.Security.Users.Engineer.IsLoggedOn): BOOL;
u01id AT %I(System.Security.Users.Engineer.Id): DINT;
u02on AT %I(System.Security.Users.Operator.IsLoggedOn): BOOL;
u02id AT %I(System.Security.Users.Operator.Id): DINT;
u03on AT %I(System.Security.Users.Supervisor.IsLoggedOn): BOOL;
u03id AT %I(System.Security.Users.Supervisor.Id): DINT;
u04on AT %I(System.Security.Users.SysAdmin.IsLoggedOn): BOOL;
u04id AT %I(System.Security.Users.SysAdmin.Id): DINT;

Output AT %M(System.Security.ActiveUserID): DINT;

END_VAR;

IF u01on = 1 THEN
Output := u01id;
ELSIF u02on = 1 THEN
Output := u02id;
ELSIF u03on = 1 THEN
Output := u03id;
ELSIF u04on = 1 THEN
Output := u04id;
ELSE
Output := 99;
END_IF;

END_PROGRAM

Thank you!

[JChamberlain]

Is that a script or logic? It looks like logic. They are two very different things in Geo SCADA!

My first suggestion to refine your approach would be to query the CDBUser table for that same field/column.

The other is rather than seeing who is logged in, query the event journal so you can see exactly who did what and when.

Adam's table here might also be useful.

[AdamWoodland]

If the logic program is called from a script on a mimic (you mention clicking a button), you can always pass the user name in as an input using VAR_INPUT.

As Jesse says, logic and scripting are two very different beasts, need to be careful what you're using and how (for example logic has no context of a user)

[BevanWeiss · Accepted solution]

Does this Logic routine actually do what you want?

I thought the problem was 2 ClearSCADAs and 1 cup RTU..  but your logic only appears to look at the one Enterprise SCADA.

As Jesse mentioned, looking at the Event Journal is probably the 'nicest' way to identify which user performed an action on the points associated with the shared RTU.  But this would need to be the Event Journal on each ClearSCADA instance right? (i.e. User A might be logged into ClearSCADA A and issuing the control, or User B might be logged into ClearSCADA B and issuing the control).

This situation is quite a bit trickier.  If you only have a radio link between the Enterprise SCADA and the Local SCADA that adds some more challenges.

What you could do is:

Have an ODBC point at each end which provides the username and timestamp of the last person that executed a command to the RTU. At the Enterprise SCADA end, also have an OPC (or other comms link) to the Local SCADA to read out the username/timestamp from the Local SCADA.  Then at the Remote SCADA you just look at which timestamp is more advanced.  and they were the last user to issue a control.  If you want that info for each point... it starts to all add up, and the radio link might not be so nice (strings are never good telemetry data).