Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 2 Process Sentinels : active_logins

active_logins
The active_logins table stores details of all users who are currently logged in to this iProcess Engine node.
Structure
The active_logins table has the following structure:
TABLE active_logins(
logical_machine_id INTEGER NOT NULL,
logical_process_name VARCHAR(10) NOT NULL,
logical_process_instance INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL,
user_id VARCHAR(37) NOT NULL,
process_id INTEGER NOT NULL,
filsh INTEGER NOT NULL,
windows SMALLINT NOT NULL,
station_id VARCHAR(32) NOT NULL)
Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
Flag that defines whether the login request came from TIBCO iProcess Objects (0) or from an TIBCO iProcess® Workspace or other SAL application (1).
Primary Key
None.
Foreign Keys
The following foreign key is defined for this table.
fk_active_logins1

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following indexes are defined for this table.
Table Activity
The active_logins table contains one row for each user who is currently logged into this iProcess Engine node.
Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved