Share this page

# PPM_LOGON_SESSIONS

This table stores information about the sessions created on the PPM server. It includes information such as session start and end time, session type, how uses logged on to PPM, PPM node on which the session was created, and how the session ended.

This table can be used in combination with KNTA_LOGON_ATTEMPTS for user sessions tracking. For example, if you want to find out the IP address of a user when connecting to PPM, you can refer to the table KNTA_LOGON_ATTEMPTS.

## Foreign Keys

There are no foreign keys for this table.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
LOGON_SESSION_ID | NOT NULL | NUMBER | System-generated identifier of the session.
USER_ID | NULLABLE | NUMBER | Identifier for the user who tried to connect
USERNAME | NULLABLE | VARCHAR2 (200) | Username of the user who tried to connect
NODE_NAME | NULLABLE | VARCHAR2 (512) | PPM node on which the session was created.
SESSION_START_TIME | NULLABLE | DATE | Session start time
SESSION_FINISH_TIME | NULLABLE | DATE | Session finish time
SESSION_TYPE | NULLABLE | VARCHAR2 (40) | Session type. Available values are: Web Workbench MSP_PLUGIN
AUTHENTICATION_TYPE | NULLABLE | VARCHAR2 (30) | Authentication type used to log on to PPM. Available values are: USERNAME_PASSWORD SITEMINDER SSO NTLM ONE_TIME_KEY LW_SSO COOKIE
SESSION_END_CAUSE | NULLABLE | VARCHAR2 (50) | How the session ended. Available values are: SIGN_OUT SESSION_TIMEOUT SERVER_GRACEFUL_SHUTDOWN SERVER_UNEXPECTED_SHUTDOWN NEW_SESSION_CREATED

Note: If the server crashes, SESSION_FINISH_TIME and SESSION_END_CAUSE will be empty for the ended sessions. Only when the server gets restarted, SESSION_END_CAUSE will be updated to SERVER_UNEXPECTED_SHUTDOWN, and SESSION_FINISH_TIME will be updated to the time when the server got restarted, not the time when the server crashed.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C0040609 | UNIQUE | 1 | LOGON_SESSION_ID
PPM_LOGON_SESSIONS_N1 | NONUNIQUE | 1 | SESSION_START_TIME
PPM_LOGON_SESSIONS_N1 | NONUNIQUE | 2 | SESSION_FINISH_TIME, NODE_NAME
PPM_LOGON_SESSIONS_N3 | NONUNIQUE | 1 | USER_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_LOGON_SESSIONS_S | LOGON_SESSION_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: