ADGroups

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Domain varchar 200 null
CanonicalName varchar 1000 null
DistinguishedName varchar 1000 null
AD_PowerBI_GroupUsers.distinguishedName Implied ConstraintR
AD_PowerBI_Stage_GroupUsers.distinguishedName Implied ConstraintR
ADUsers.distinguishedName Implied ConstraintR
ADUsers_Monthly.distinguishedName Implied ConstraintR
VW_ADUsers.distinguishedName Implied ConstraintR
VW_ADUsers_Monthly.distinguishedName Implied ConstraintR
GroupCategory varchar 200 √ null
GroupScope varchar 200 √ null
Name varchar 200 √ null
ObjectClass varchar 100 √ null
ObjectGUID varchar 200 √ null
SamAccountName varchar 200 √ null
SID varchar 200 √ null
AVA_insdate datetime2 16 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_ADGroups Primary key Asc DistinguishedName

Relationships

Close relationships within degrees of separation