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 |