The Login/Logout Change Log
The LoginLogoutChangeLog_viw view contains timestamp, administrative and client login, and application name data. In the event of switchover, logout will not be tracked as the subsystem to track login and logout is no longer operational. After a switchover, only new logins are logged in the database table.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason | CX Insights Name | CX Insights Type | CX Insights Folder Name |
|---|---|---|---|---|---|---|---|---|---|
| Id | int | False | No | A unique identifier representing this row. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ApplicationId | smallint | False | No | The client Application ID. |
15.2.0.516 | Added for storing application login and logout information. | |||
| Action | smallint | False | No | The action type, for example, Login or Logout. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionDateTime | datetime2 | False | No | The timestamp when the action happens. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionDateTimeGMT | datetime2 | False | No | The GMT timestamp when the action happens. |
15.2.0.516 | Added for storing application login and logout information. | |||
| UserId | nvarchar (50) | True | Yes | The userid, who logged in to or logged out from the application. |
15.2.0.516 | Added for storing application login and logout information. | |||
| Station | nvarchar (50) | True | Depends on customer usage | The station used to log in to or log out from the application. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ICServer | nvarchar (50) | True | No | The machine or IC server the application logged in to or logged out from. |
15.2.0.516 | Added for storing application login and logout information. | |||
| SessionManagerInstanceId | nvarchar (50) | True | No | The SessionManager instance Id. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionResult | nvarchar (50) | True | No | The result of the login/logout action. This will be an error code if the login/logout action fails. If the action succeeds, the value will be null. |
15.2.0.516 | Added for storing application login and logout information. | |||
| I3TimeStampGMT | datetime | False | No | Used by the data records purging mechanism. |
15.2.0.516 | Added for storing application login and logout information. | |||
| SiteId | smallint | False | No | The site identifier. |
15.2.0.516 | Added for storing application login and logout information. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason | CX Insights Name | CX Insights Type | CX Insights Folder Name |
|---|---|---|---|---|---|---|---|---|---|
| Id | number | False | No | A unique identifier representing this row. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ApplicationId | number | False | No | The client Application ID. |
15.2.0.516 | Added for storing application login and logout information. | |||
| Action | number | False | No | The action type, for example, Login or Logout. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionDateTime | date | False | No | The timestamp when the action happens. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionDateTimeGMT | date | False | No | The GMT timestamp when the action happens. |
15.2.0.516 | Added for storing application login and logout information. | |||
| UserId | nvarchar2 (50) | True | Yes | The userid, who logged in to or logged out from the application. |
15.2.0.516 | Added for storing application login and logout information. | |||
| Station | nvarchar2 (50) | True | Depends on customer usage | The station used to log in to or log out from the application. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ICServer | nvarchar2 (50) | True | No | The machine or IC server the application logged in to or logged out from. |
15.2.0.516 | Added for storing application login and logout information. | |||
| SessionManagerInstanceId | nvarchar2 (50) | True | No | The SessionManager instance Id. |
15.2.0.516 | Added for storing application login and logout information. | |||
| ActionResult | nvarchar2 (50) | True | No | The result of the login/logout action. This will be an error code if the login/logout action fails. If the action succeeds, the value will be null. |
15.2.0.516 | Added for storing application login and logout information. | |||
| I3TimeStampGMT | date | False | No | Used by the data records purging mechanism. |
15.2.0.516 | Added for storing application login and logout information. | |||
| SiteId | number | False | No | The site identifier. |
15.2.0.516 | Added for storing application login and logout information. |