ADUsers

10759 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Domain varchar 200 null
userPrincipalName varchar 200 null
VW_AD_PowerBI_GroupMembers.userPrincipalName Implied ConstraintR
VW_ADGroupMembers.userPrincipalName Implied ConstraintR
VW_ADUsers.userPrincipalName Implied ConstraintR
VW_ADUsers_Monthly.userPrincipalName Implied ConstraintR
samAccountName varchar 100 null
distinguishedName varchar 1000 null
ADGroups.DistinguishedName Implied ConstraintR
Company varchar 200 √ null
title varchar 200 √ null
mail varchar 200 √ null
department varchar 200 √ null
userAccountControl int 4 √ null
LastLogon bigint 8 √ null
LastLogonDate datetime2 16 √ null
cn varchar 200 √ null
GivenName varchar 100 √ null
sn varchar 100 √ null
DisplayName varchar 250 √ null
Description varchar 2000 √ null
usnCreated int 4 √ null
whenChanged datetime2 16 √ null
whenCreated datetime2 16 √ null
wWWHomePage varchar 500 √ null
ObjectCategory varchar 200 √ null
ObjectClass varchar 200 √ null
AVA_insdate datetime2 16 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_ADUsers Primary key Asc userPrincipalName

Relationships

Close relationships within degrees of separation