dbo.ADSMachine
Active Directory computers
TableType TUsage USERDATARows 1SizeMB 0.064
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSMachine | varchar(38) | no | Computer | PKUID |
UID_Hardware | varchar(38) | yes | Device | FKUID |
UID_ADSGroupPrimary | varchar(38) | yes | Primary group | FKUID |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
ObjectGUID | varchar(36) | yes | Object GUID | |
SAMAccountName | nvarchar(40) | yes | Computer name (pre Win2000) | |
ObjectClass | nvarchar(510) | yes | Object class | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
ObjectSID | nvarchar(510) | yes | Object SID | |
UID_ADSContainer | varchar(38) | yes | Container | FKUID |
cn | nvarchar(220) | no | Name | |
DNSHostName | nvarchar(512) | yes | DNS host name | |
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 |
ObjectKeyManager | varchar(138) | yes | Account manager | |
UID_ADSDomain | varchar(38) | no | Domain | FKUID |
MachineRole | nvarchar(-1) | yes | Function | limited |
OperatingSystem | nvarchar(-1) | yes | Operating system | |
OperatingSystemHotfix | nvarchar(-1) | yes | Operating system hotfix | |
OperatingSystemServicePack | nvarchar(-1) | yes | Operating system service pack | |
OperatingSystemVersion | nvarchar(-1) | yes | Operating system version | |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
SIDHistory | nvarchar(-1) | yes | Object SID history | |
IsProtectedFromAccidentalDel | bit(1) | yes | Protected from accidental deletion | |
MSDsConsistencyGuid | nvarchar(512) | yes | Azure AD Connect anchor ID |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL1302 | ADSMachineInADSSite.UID_ADSMachine | ADSMachine.UID_ADSMachine |
| ADS_RFRL1500 | ADSDomain.UID_ADSMachineRIDMaster | ADSMachine.UID_ADSMachine |
| ADS_RFRL2452 | ADSMachine.UID_Hardware | Hardware.UID_Hardware |
| ADS_RFRL2555 | ADSPrinter.UID_ADSMachine | ADSMachine.UID_ADSMachine |
| ADS_RFRL2571 | ADSMachine.UID_ADSDomain | ADSDomain.UID_ADSDomain |
| ADS_RFRL755 | ADSMachine.UID_ADSContainer | ADSContainer.UID_ADSContainer |
| ADS_RFRL871 | ADSMachine.UID_ADSGroupPrimary | ADSGroup.UID_ADSGroup |
Triggers
ADS_TDADSMachine SQL_TRIGGER
ADS_TIADSMachine SQL_TRIGGER
ADS_TUADSMachine SQL_TRIGGER
GEN_T1AEF631BFB74E59F11389C4C1 SQL_TRIGGER
GEN_T2EBBC9B7E3BC2E0B9D52EF4C3 SQL_TRIGGER
GEN_T3C7368EFDEA8BE28374A038B7 SQL_TRIGGER
GEN_T5721EB8EE65CDF36B3D9F00F8 SQL_TRIGGER
GEN_T60E2CA401DC67FB2114917E7D 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.ADS_RADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZAllForOneHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZAllForOneWorkDesk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZWorkDeskInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTLicenseOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TDDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIDomainTrustsDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSMachine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1901D1BF972675A0C4EBF086B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T24070400B143AFEFB8844DC2B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T466C44EA8A4D3BE37F57BAE44 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T52E3F4D75FFB9821A5B969F8B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5721EB8EE65CDF36B3D9F00F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5C8317E6E6DA290D604CB8F6D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_VElementAndRoot | SQL expression dependency | dbo · UID_ADSMachine · 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 |
| dbo.ADS_VElementManagerValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VGroupMemberValid_Machine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVContainerAndMembers | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADSVUniqueItems | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMSystemMetering | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVHardwareAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSMachineInADSSite | foreign key references table | ADS_RFRL1302: ADSMachineInADSSite.UID_ADSMachine -> ADSMachine.UID_ADSMachine |
| ADSDomain | foreign key references table | ADS_RFRL1500: ADSDomain.UID_ADSMachineRIDMaster -> ADSMachine.UID_ADSMachine |
| Hardware | referenced by foreign key from table | ADS_RFRL2452: ADSMachine.UID_Hardware -> Hardware.UID_Hardware |
| ADSPrinter | foreign key references table | ADS_RFRL2555: ADSPrinter.UID_ADSMachine -> ADSMachine.UID_ADSMachine |
| ADSDomain | referenced by foreign key from table | ADS_RFRL2571: ADSMachine.UID_ADSDomain -> ADSDomain.UID_ADSDomain |
| ADSContainer | referenced by foreign key from table | ADS_RFRL755: ADSMachine.UID_ADSContainer -> ADSContainer.UID_ADSContainer |
| ADSGroup | referenced by foreign key from table | ADS_RFRL871: ADSMachine.UID_ADSGroupPrimary -> ADSGroup.UID_ADSGroup |
| dbo.ADS_RADSMachineInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZADSMachineInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZAllForOneHardware | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ADS_ZAllForOneWorkDesk | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ADS_ZWorkDeskInADSGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_FTLicenseOverview | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.ADS_TDDomainTrustsDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TIBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TIDomainTrustsDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUAdsGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUADSMachine | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUADSMachineInADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUHardware | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-ads-customizer-ads-customizer-adsmachine.cs | decompiled C# reference | classes ADSMachine; methods MoveNext, SetStateMachine, OnSavingAsync, OnSavedAsync, _CheckUidADSDomain, _CheckADSPrimaryGroup; references ADSContainer, ADSDomain, ADSGroup, ADSMachine, ADSMachineInADSGroup; markers reads entity values, references DB/Dialog objects |