dbo.ADSPrinter
Active Directory printers
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ADSPrinter | varchar(38) | no | Active Directory printer | PKUID |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
uncName | nvarchar(512) | yes | UNC Name | |
Description | nvarchar(2048) | yes | Description | |
PortName | nvarchar(512) | yes | Port | |
IsPrintColor | bit(1) | yes | Color | |
IsPrintDuplexSupported | bit(1) | yes | Duplex | |
PrintPagesPerMinute | int(4) | yes | Pages per minute | |
IsPrintStaplingSupported | bit(1) | yes | Supports sorter | |
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_ADSMachine | varchar(38) | no | Active Directory computer | FKUID |
Location | nvarchar(-1) | yes | Location description | |
printMaxResolutionSupported | int(4) | yes | Max. resolution [dpi] | |
PrintMaxXExtent | int(4) | yes | Max. horizontal resolution | |
PrintMaxYExtent | int(4) | yes | Max. vertical resolution | |
DriverName | nvarchar(-1) | yes | Driver | |
PrinterName | nvarchar(128) | yes | Printername | |
ServerName | nvarchar(510) | yes | Full server name | |
ShortServerName | nvarchar(510) | yes | Server | |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
ObjectGUID | varchar(36) | yes | Object GUID | |
CanonicalName | nvarchar(2000) | yes | Canonical name |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2555 | ADSPrinter.UID_ADSMachine | ADSMachine.UID_ADSMachine |
Triggers
GEN_T2FF770DA2D9C1282109B39EC7 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.ADSVUniqueItems | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSMachine | referenced by foreign key from table | ADS_RFRL2555: ADSPrinter.UID_ADSMachine -> ADSMachine.UID_ADSMachine |