Session

Contains information about current work sessions of users. Also used for managing resources allocated for sessions and locks.

Key	Name	Type	Required	Description
PK	Id	int	yes	Identifier of a connection session.
	CreationDate	datetime	yes	Date and time of the creation of a session.
	CurrentEditSessionId	int	no	Identifier of the current editing session from the EditSession table
	CurrentTaskId	int	no	Identifier of the current task.
	CurrentTaskStartTime	datetime	no	Date and time when processing of the current task was started.
	InstanceId	int	yes	Identifier of the process to which a session belongs.
	LastAccess	datetime	yes	Date and time of the last query to the server.
	RoleId	int	no	User role type. Possible values are listed in the User Role Types table.
	TimeoutMinutes	int	no	The time a session can remain inactive before it is closed, in minutes.
	UserId	int	yes	Identifier of the user that created the session. Corresponds to the identifier in the Principal table.
	WorkStation	nvarchar	yes	Name of the computer from which the session was created.
	WorkstationType	int	no	Type of workstation from which the session was created. Standard values are listed in the Station Types table.

3/2/2021 8:10:41 AM

Please leave your feedback about this article