Expand All Collapse All
The Login/Logout Change Log

LoginLogoutChangeLog_viw View

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.

  • Last Changed Version - 15.2.0.516
  • Last Changed Reason - Added for storing application login and logout information.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
ApplicationName nvarchar (50) False No

The client Application name, for example, Interaction Client or Interaction Administrator.

 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.
ErrorDescription nvarchar (50) True No

A descriptive message about the error happening during a login. The values are populated from the ICErrorCodeLookup table that has error codes and error descriptions.

 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.