Copyright © Cloud Software Group, Inc. All rights reserved.

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)

Column	Description
logical_machine_id	ID of the server where the process that made the login request is running, as defined in the node_cluster table.
logical_process_name	Logical name of this process instance. Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
logical_process_ instance	ID of this process instance, as defined in the process_config table.
user_name	Name of the user who is logged in, as defined in the user_names table.
user_id	ID of the user who made the login request (for internal use only).
process_id	Process ID (PID) of the process that made the login request.
filsh	FIL session handle (for internal use only).
windows	Flag that defines whether the login request came from TIBCO iProcess Objects (0) or from an TIBCO iProcess® Workspace or other SAL application (1).
station_id	Comment that identifies where a user is logged in.

Primary Key

None.

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_active_logins1	logical_machine_id	node_cluster

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following indexes are defined for this table.

Index Name	Column(s) Indexed
idx_activelogns_fk	logical_machine_id
idx_active_logins	user_id

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.

A row is...	When...
added	a user is logged in.
updated	never.
deleted	a user is logged out or the iProcess Engine shuts down.

Copyright © Cloud Software Group, Inc. All rights reserved.