dbo.ADSPolicy
Active Directory account policies
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSPolicy | varchar(38) | no | Account policy | PKUID |
cn | nvarchar(220) | no | Name | |
Description | nvarchar(2048) | yes | Description | |
DistinguishedName | nvarchar(800) | no | Distinguished name | |
CanonicalName | nvarchar(800) | yes | Canonical name | |
displayNamePrintable | nvarchar(-1) | yes | Simple display | |
DisplayName | nvarchar(510) | yes | Display name | |
msDSLockoutDuration | int(4) | yes | Block duration [min] | |
msDSLockoutObservationWindow | int(4) | yes | Reset account [min] | |
msDSLockoutThreshold | int(4) | yes | Max. failed logins | |
msDSMaximumPwdAge | bigint(8) | yes | Max. password lifetime | |
msDSMinimumPwdAge | int(4) | yes | Min. password lifetime | |
msDSMinimumPwdLength | int(4) | yes | Min. password length | |
msDSPwdSettingsPrecedence | int(4) | yes | Ranking | |
msDSPwdReversibleEncryption | bit(1) | yes | Save password with reversible encryption | |
msDSPwdHistoryLength | int(4) | yes | Password history | |
msDSPwdComplexity | bit(1) | yes | Complex passwords | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_ADSDomain | varchar(38) | no | Domain | FKUID |
ObjectGUID | varchar(36) | yes | Object GUID | |
XDateSubItem | datetime(8) | yes | Dependencies modified on |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL1784 | ADSPolicy.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL2572 | ADSPolicyAppliesTo.UID_ADSPolicy | ADSPolicy.UID_ADSPolicy |
Triggers
GEN_T2AB646BC907681E2B02480A3F SQL_TRIGGER
GEN_T5E2425822695D53DC152E72F3 SQL_TRIGGER
GEN_T6FDF1186B3204F04C3AAC9870 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_T457B7B9C10E4B320E366A05AA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T473D0BF02E5A45B69D47EA698 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5BEF9F6CE7518DE970F33A611 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E2425822695D53DC152E72F3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5F140BE06740EDBE380D44AB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6012ADB32C2DA9EF7D1D48E01 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T69EBD2189654166448C0A3EFF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSDomain · OBJECT_OR_COLUMN |
| ADSDomain | referenced by foreign key from table | ADS_RFRL1784: ADSPolicy.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSPolicyAppliesTo | foreign key references table | ADS_RFRL2572: ADSPolicyAppliesTo.UID_ADSPolicy -> ADSPolicy.UID_ADSPolicy |