Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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	 number(5)	        NOT NULL,
    	logical_process_name	 varchar2(10)  		NOT NULL,
    	logical_process_instance number(5)	        NOT NULL,
    	user_name 	  	 varchar2(64)  		NOT NULL,
    	user_id	                 varchar2(37)  		NOT NULL,
    	process_id		 number(10)	        NOT NULL,
    	filsh			 number(5)	        NOT NULL,
    	windows			 number(2) 	        NOT NULL,
    	station_id		 varchar2(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 This key enforces the DELETE CASCADE referential action.` | `logical_machine_id` | node_cluster

## Indexes

The following indexes are defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_active_ logins_fk` | `logical_machine_id` | SMALLINDEXSPACE
`idx_active_logins` | `user_id` | MEDIUMINDEXSPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | SMALLTABLESIZE
Percentage Increase | SMALLTABLEPCTINCREASE
Tablespace | SMALLTABLESPACE

## 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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine