vkadComputers

Contains active directory harvested computers

Column Name

Type

Purpose

Name

nvarchar(255), not null

AD Computer name

CanonicalName

nvarchar(255), not null

Canonical name

DomainName

nvarchar(255), null

Domain name

DistinguishedName

nvarchar(2048), null

AD distinguished name

OperatingSystem

nvarchar(30), null

Operating System

OperatingSystemVersion

nvarchar(20), null

Operating System version

LastLogon

datetime(3), null

Last time machine was rebooted

LastLogoff

datetime(3), null

Last time machine was shutdown

DNSHostName

nvarchar(255), null

Dns host name

WhenCreated

datetime(3), null

When the machine was made member of AD

WhenChanged

datetime(3), null

When the machine AD properties/role was updated