|
|
|
|
vkadUsers |
Contains active directory harvested users. |
|
Column Name |
Type |
Purpose |
logonName |
nvarchar(255), not null |
AD User name |
CanonicalName |
nvarchar(255), not null |
Canonical name |
DomainName |
nvarchar(255), null |
Domain name |
DistinguishedName |
nvarchar(2048), null |
AD distinguished name |
varchar(200), null |
User email address |
|
phone |
varchar(100), null |
User phone number |
givenName |
nvarchar(50), null |
User first name |
sirName |
nvarchar(50), null |
User last name |
LastLogon |
datetime(3), null |
Last time user logged on |
LastLogoff |
datetime(3), null |
Last time user logged off |
SAMAccountName |
nvarchar(255), null |
sAMAccount name (pre Win-2K account logon name) |
Description |
nvarchar(300), null |
User account description |
WhenCreated |
datetime(3), null |
When the user was made member of AD |
WhenChanged |
datetime(3), null |
When the user AD properties was updated |
PwdLastSet |
datetime(3), null |
When the user password was last set. |