> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# activeuser table

> 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.

## 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   |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/activeuser.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=89119b96a0916c4efa53028c102f3112" alt="activeuser table relationship diagram" width="371" height="59" data-path="media/loc/en/database/tables/activeuser.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                    | Description                                 |
| ------------------------ | ------------------------------------------- |
| [traveller](./traveller) | Associates traveling out from this database |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Security](/en/automation/crmscript/security/index.md)
- [traveller table](/en/database/tables/traveller.md)
- [Trigger](/en/automation/trigger/reference/CRMScript.Event.Trigger.md)
- [Saving a request](/en/automation/event-model/saving-a-request.md)
- [Blocked tables list](/en/online/mirroring/blocked-tables.md)
- [extra_tables table](/en/database/tables/extra-tables.md)