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