Diagrams

Table

Active Session

DynamicsDocs.comActive Session«Table 2000000110»Active SessionUser SIDServer Instance ID [PK]Session ID [PK]Server Instance NameServer Computer NameUser IDClient Type; [Windows Client,SharePoin...Client Computer NameLogin DatetimeDatabase NameSession Unique ID«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 2000000112»Server InstanceServer Instance ID [PK]Service NameServer Computer NameLast ActiveServer Instance NameServer PortManagement PortStatus; [Started,Stopped,Crashed]<User SID><Server Instance ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 User SID (User SID) GUID
2 Server Instance ID (Server Instance ID) Integer
3 Session ID (Session ID) Integer
4 Server Instance Name (Server Instance Name) Text250
5 Server Computer Name (Server Computer Name) Text250
6 User ID (User ID) Text132
7 Client Type (Client Type) Option
8 Client Computer Name (Client Computer Name) Text250
9 Login Datetime (Login Datetime) DateTime
10 Database Name (Database Name) Text250
11 Session Unique ID (Session Unique ID) GUID

Keys

# Fields
0 Server Instance ID,Session ID (Server Instance ID,Session ID) Clustered: Yes
1 Login Datetime (Login Datetime)
2 User SID,Client Type (User SID,Client Type)

Table Relations To Other Tables

Field Related Table Related Field
Server Instance ID (Server Instance ID) Server Instance Server Instance ID (Server Instance ID) 1..n
User SID (User SID) User User Security ID (User Security ID) 1..n

Table Relations From Other Tables

From Table From Field