Next Topic

Previous Topic

Book Contents

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.