activeuser table - SuperOffice

activeuser Table (28)

Currently logged-on users. This table contains encrypted license information. Changing it may disable login for all users and require intervention by SuperOffice support. Recommended use; for determining who is logged on, at what location, etc.

Fields

Name	Description	Type	Nullable
activeuser_id	Note: This ID is not assigned from sequence, but instead corresponds to the Associate primary key	PK	No
lastlogin	Date of last login	DateTime	Yes
netAddress	DNS and numeric IP address	String(127)	Yes
clientType	1=CRM , 2=Admin, 3=SOQL, …	UShort	Yes
computerName	Computer name	String(127)	Yes
domainName	Domain name	String(127)	Yes
osUserName	OS user name currently logged on	String(127)	Yes

Indexes

Fields	Types	Description

Relationships

Table	Description
traveller	Associates traveling out from this database

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Security traveller table Trigger Saving a request Blocked tables list extra_tables table

⌘I