1E 8.1 (on-premises)

Core

Display the User Interaction state for all user sessions.

(None)

DoNotDisturb (boolean): Indicates whether this user session has been set to Do Not Disturb mode.

FocusedExecutable (string): The executable image filename for the process that is in the foreground.

This may be empty if there is no active foreground window.

LastInteractionTime (string): The last time that input was received for this user session. Typically the last time mouse or keyboard input was received.

LastNotificationShown (string): The last time that the 1E Client displayed a notification or pop-up for this user session.

LastStateChangeTime (string): The last time that a session state change was detected, such as screen lock or unlock.

LogonTime (string): The logon time for this session.

NotificationState (string): Current Notification state, which will be one of:

SessionId (integer): Id of the logon session for this user.

StartupTime (string): Start up time of the 1E Client UI in this session.

UserName (string): Username of the logon session.

@interaction = Interaction.GetInteractionState();

SELECT  "Last interaction from " || UserName || " was " 
        || CAST((JULIANDAY(DATETIME("now")) - JULIANDAY(DATETIME(LastInteractionTime))) * 1440 AS INTEGER)
        || " minutes ago" AS LastActivity
FROM    @interaction;

Use of this method may have user privacy implications (please observe local regulations).