ST_USERS

This table provides a list of all users.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

User ID

3

Full_Name

varchar

254

N

Full Name

4

Phone

varchar

254

N

Phone

5

VoiceMail

varchar

254

N

Voice Mail

6

Pager

varchar

254

N

Pager

7

Fax

varchar

254

N

Fax

8

Email_Address

varchar

254

N

Email Address

9

Address

varchar

254

N

Address

10

CreatedTime

datetime

254

N

CreatedTime

11

AccountStatus

varchar

254

N

Account Status

12

LogonName

varchar

254

N

Logon Name

13

HasFixedLicense

int

4

N

Has a fixed license

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_USERS

ServerID

ST_GROUPUSERS

ServerID

2

ST_USERS

ID

ST_GROUPUSERS

UserID

1

ST_USERS

ServerID

ST_OBJECTACLS

ServerID

2

ST_USERS

ID

ST_OBJECTACLS

ObjectID

1

STSERVER

ServerID

STUSERS

ServerID