SSIS Components for Microsoft Active Directory

Build 23.0.8839

PrintQueue

Contains information about a print queue.

Columns

Name Type ReadOnly References DataFormat Description
Id [KEY] String True

Combined index and DN. Multiple indices are only possible when a column is set to SplitDataByRow.

DN String True

The full distinguished name.

RDN String False

The relative distinguished name.

BaseDN String True

The base distinguished name.

InstanceType String False DelimitedData

A bitfield that dictates how the object is instantiated on a particular server. The value of this attribute can differ on different replicas even if the replicas are in sync.

NTSecurityDescriptor String False DelimitedData

The Windows NT security descriptor for the schema object. A security descriptor is a data structure that contains security information about an object, such as the ownership and permissions of the object.

ObjectCategory String False DelimitedData

An object class name used to group objects of this or derived classes.

ObjectClass String False DelimitedData

The list of classes from which this class is derived.

PrinterName String False DelimitedData

The display name of an attached printer.

ServerName String False DelimitedData

The name of a server.

ShortServerName String False DelimitedData

Pre-Windows 2000 compatible server name for print servers.

UNCName String False DelimitedData

The universal naming convention name for shared volumes and printers.

AdminDescription String False DelimitedData

The description displayed on admin screens.

AdminDisplayName String False DelimitedData

The name to be displayed on admin screens.

AllowedAttributes String False DelimitedData

Attributes that will be permitted to be assigned to a class.

AllowedAttributesEffective String False DelimitedData

A list of attributes that can be modified on the object.

AllowedChildClasses String False DelimitedData

Classes that can be contained by a class.

AllowedChildClassesEffective String False DelimitedData

A list of classes that can be modified.

AssetNumber String False DelimitedData

The tracking number for the object.

BridgeheadServerListBL String False DelimitedData

The list of servers that are bridgeheads for replication.

BytesPerMinute String False DelimitedData

Printer data transfer rate.

CanonicalName String False DelimitedData

The name of the object in canonical format. myserver2.fabrikam.com/users/jeffsmith is an example of a distinguished name in canonical format. This is a constructed attribute. The results returned are identical to those returned by the following Active Directory function: DsCrackNames(NULL, DS_NAME_FLAG_SYNTACTICAL_ONLY, DS_FQDN_1779_NAME, DS_CANONICAL_NAME, ...).

Cn String False DelimitedData

The name that represents an object. Used to perform searches.

CreateTimeStamp Datetime False DelimitedData

The date when this object was created. This value is replicated.

DefaultPriority String False DelimitedData

The default priority (of a process, print job, and so on).

Description String False DelimitedData

Contains the description to display for an object. This value is restricted as single-valued for backward compatibility in some cases but is allowed to be multi-valued in others. See Remarks.

DisplayName String False DelimitedData

The display name for an object. This is usually the combination of the users first name, middle initial, and last name.

DisplayNamePrintable String False DelimitedData

The printable display name for an object. The printable display name is usually the combination of the user's first name, middle initial, and last name.

DriverName String False DelimitedData

The device driver name.

DriverVersion String False DelimitedData

The Version number of device driver.

DSASignature String False DelimitedData

The DSA-Signature of an object is the Invocation-ID of the last directory to modify the object.

DSCorePropagationData String False DelimitedData

The DS-Core-Propagation-Data attribute is for internal use only.

ExtensionName String False DelimitedData

The name of a property page used to extend the UI of a directory object.

Flags String False DelimitedData

To be used by the object to store bit information.

FromEntry String False DelimitedData

This is a constructed attribute that is TRUE if the object is writable and FALSE if it is read-only, for example, a GC replica instance.

FrsComputerReferenceBL String False DelimitedData

Reference to replica sets to which this computer belongs.

FRSMemberReferenceBL String False DelimitedData

Reference to subscriber objects for this member.

FSMORoleOwner String False DelimitedData

Flexible Single-Master Operation: The distinguished name of the DC where the schema can be modified.

IsCriticalSystemObject String False DelimitedData

If TRUE, the object hosting this attribute must be replicated during installation of a new replica.

IsDeleted String False DelimitedData

If TRUE, this object has been marked for deletion and cannot be instantiated. After the tombstone period has expired, it will be removed from the system.

MemberOf String False DelimitedData

The distinguished name of the groups to which this object belongs.

IsPrivilegeHolder String False DelimitedData

Backward link to privileges held by a given principal.

Keywords String False DelimitedData

A list of keywords that can be used to locate a given connection point.

LastKnownParent String False DelimitedData

The Distinguished Name (DN) of the last known parent of an orphaned object.

Location String False DelimitedData

The user's location, such as office number.

ManagedBy String False DelimitedData

The distinguished name of the user that is assigned to manage this object.

ManagedObjects String False DelimitedData

Contains the list of objects that are managed by the user. The objects listed are those that have the property managedBy property set to this user. Each item in the list is a linked reference to the managed object.

MasteredBy String False DelimitedData

Backward link for Has-Master-NCs attribute. The distinguished name for its NTDS Settings objects.

ModifyTimeStamp Datetime False DelimitedData

A computed attribute that represents the date when this object was last changed. This value is not replicated.

MS-DS-ConsistencyChildCount String False DelimitedData

This attribute is used to check consistency between the directory and another object, database, or application, by comparing a count of child objects.

MS-DS-ConsistencyGuid String False DelimitedData

This attribute is used to check consistency between the directory and another object, database, or application, by comparing GUIDs.

NetbootSCPBL String False DelimitedData

A list of service connection points that reference this NetBoot server.

NonSecurityMemberBL String False DelimitedData

List of nonsecurity-members for an Exchange distribution list.

DistinguishedName String False DelimitedData

Same as the Distinguished Name for an object. Used by Exchange.

ObjectGUID String False DelimitedData

The unique identifier for an object.

ObjectVersion String False DelimitedData

This can be used to store a version number for the object.

OperatingSystem String False DelimitedData

The Operating System name, for example, Windows Vista Enterprise.

OperatingSystemHotfix String False DelimitedData

The hotfix level of the operating system.

OperatingSystemServicePack String False DelimitedData

The operating system service pack ID string (for example, SP3).

OperatingSystemVersion String False DelimitedData

The operating system version string, for example, 4.0.

OtherWellKnownObjects String False DelimitedData

Contains a list of containers by GUID and Distinguished Name. This permits retrieving an object after it has been moved by using just the GUID and the domain name. Whenever the object is moved, the system automatically updates the Distinguished Name.

PartialAttributeDeletionList String False DelimitedData

Tracks the internal replication state of partial replicas (that is, on GCs). Attribute of the partial replica NC object. Used when the GC is in the process of removing attributes from the objects in its partial replica NCs.

PartialAttributeSet String False DelimitedData

Tracks the internal replication state of partial replicas (that is, on GCs). Attribute of the partial replica NC object. Defines the set of attributes present on a particular partial replica NC.

PhysicalLocationObject String False DelimitedData

Used to map a device (for example, a printer, computer, and so on) to a physical location.

PortName String False DelimitedData

List of port names. For example, for printer ports or comm ports.

PossibleInferiors String False DelimitedData

The list of objects that this object can contain.

PrintAttributes String False DelimitedData

A bitmask of printer attributes.

PrintBinNames String False DelimitedData

A list of printer bin names.

PrintCollate String False DelimitedData

TRUE if a printer has collating bins.

PrintColor String False DelimitedData

TRUE if a printer can print in color.

PrintDuplexSupported String False DelimitedData

Indicates the type of duplex support a printer has.

PrintEndTime String False DelimitedData

The time a print queue stops servicing jobs.

PrintFormName String False DelimitedData

The name of the currently loaded form.

PrintKeepPrintedJobs String False DelimitedData

TRUE if printed jobs are kept.

PrintLanguage String False DelimitedData

The supported page description language (for example, PostScript, PCL).

PrintMACAddress String False DelimitedData

The user-supplied MAC address.

PrintMaxCopies String False DelimitedData

The maximum number of copies a device can print.

PrintMaxResolutionSupported String False DelimitedData

The maximum printer resolution.

PrintMaxXExtent String False DelimitedData

The maximum horizontal print region.

PrintMaxYExtent String False DelimitedData

The maximum vertical print region.

PrintMediaReady String False DelimitedData

A list of available media for a printer.

PrintMediaSupported String False DelimitedData

A list of media supported by a printer.

PrintMemory String False DelimitedData

The amount of memory installed in a printer.

PrintMinXExtent String False DelimitedData

The minimum horizontal print region.

PrintMinYExtent String False DelimitedData

The minimum vertical print region.

PrintNetworkAddress String False DelimitedData

The user-supplied network address.

PrintNotify String False DelimitedData

A user-supplied string that specifies the notification contact.

PrintNumberUp String False DelimitedData

The number of page images per sheet.

PrintOrientationsSupported String False DelimitedData

The page rotation for landscape printing.

PrintOwner String False DelimitedData

A user-supplied owner string.

PrintPagesPerMinute String False DelimitedData

Driver-supplied print rate in pages per minute.

PrintRate String False DelimitedData

Driver-supplied print rate.

PrintRateUnit String False DelimitedData

Driver-supplied print rate unit.

PrintSeparatorFile String False DelimitedData

The file path of the printer separator page.

PrintShareName String False DelimitedData

The printer's share name.

PrintSpooling String False DelimitedData

A string that represents the type of printer spooling.

PrintStaplingSupported String False DelimitedData

TRUE if the printer supports stapling. Supplied by the driver.

PrintStartTime String False DelimitedData

The time a print queue begins servicing jobs.

PrintStatus String False DelimitedData

Status from the print spooler. Currently unused.

Priority String False DelimitedData

The current priority (of a process, print job, and so on).

ProxiedObjectName String False DelimitedData

This attribute is used internally by Active Directory to help track interdomain moves.

ProxyAddresses String False DelimitedData

A proxy address is the address by which a Microsoft Exchange Server recipient object is recognized in a foreign mail system. Proxy addresses are required for all recipient objects, such as custom recipients and distribution lists.

QueryPolicyBL String False DelimitedData

List of all objects holding references to a given Query-Policy.

Name String False DelimitedData

The Relative Distinguished Name (RDN) of an object. An RDN is the relative portion of a distinguished name (DN), which uniquely identifies an LDAP object.

ReplPropertyMetaData String False DelimitedData

Tracks internal replication state information for DS objects. Information here can be extracted in public form through the public API DsReplicaGetInfo(). Present on all DS objects.

ReplUpToDateVector String False DelimitedData

Tracks internal replication state information for an entire NC. Information here can be extracted in public form through the API DsReplicaGetInfo(). Present on all NC root objects.

DirectReports String False DelimitedData

Contains the list of users that directly report to the user. The users listed as reports are those that have the property manager property set to this user. Each item in the list is a linked reference to the object that represents the user.

RepsFrom String False DelimitedData

Lists the servers from which the directory will accept changes for the defined naming context.

RepsTo String False DelimitedData

Lists the servers that the directory will notify of changes and servers to which the directory will send changes on Request for the defined naming context.

Revision String False DelimitedData

The revision level for a security descriptor or other change. Only used in the sam-server and ds-ui-settings objects.

SDRightsEffective String False DelimitedData

This constructed attribute returns a single DWORD value that can have up to three bits set:

ServerReferenceBL String False DelimitedData

Found in the domain naming context. The distinguished name of a computer under the sites folder.

ShowInAdvancedViewOnly String False DelimitedData

TRUE if this attribute is to be visible in the Advanced mode of the UI.

SiteObjectBL String False DelimitedData

The list of distinguished names for subnets that belong to this site.

SubRefs String False DelimitedData

List of subordinate references of a Naming Context.

SubSchemaSubEntry String False DelimitedData

The distinguished name for the location of the subschema object where a class or attribute is defined.

SystemFlags String False DelimitedData

An integer value that contains flags that define additional properties of the class. See Remarks.

USNChanged String False DelimitedData

The update sequence number (USN) assigned by the local directory for the latest change, including creation. See also , USN-Created.

USNCreated String False DelimitedData

The update sequence number (USN) assigned at object creation. See also, USN-Changed.

USNDSALastObjRemoved String False DelimitedData

Contains the update sequence number (USN) for the last system object that was removed from a server.

USNIntersite String False DelimitedData

The update sequence number (USN) for inter-site replication.

USNLastObjRem String False DelimitedData

Contains the update sequence number (USN) for the last non-system object that was removed from a server.

USNSource String False DelimitedData

Value of the USN-Changed attribute of the object from the remote directory that replicated the change to the local server.

VersionNumber String False DelimitedData

A general purpose version number.

WbemPath String False DelimitedData

References to objects in other ADSI namespaces.

WellKnownObjects String False DelimitedData

This attribute contains a list of well-known object containers by GUID and distinguished name. The well-known objects are system containers. This information is used to retrieve an object after it has been moved by using just the GUID and the domain name. Whenever the object is moved, the system automatically updates the Distinguished Name portion of the Well-Known-Objects values that referred to the object. The file Ntdsapi.h contains the following definitions, which can be used to retrieve an object (the GUIDs that are associated to these objects are contained in Ntdsapi.h):

WhenChanged Datetime False DelimitedData

The date when this object was last changed. This value is not replicated and exists in the global catalog.

WhenCreated Datetime False DelimitedData

The date when this object was created. This value is replicated and is in the global catalog.

WWWHomePage String False DelimitedData

A web page that is the primary landing page of a website.

Url String False DelimitedData

A list of alternate webpages.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Filter String

Defines the LDAP filter explicitly, overriding any other values set in the WHERE clause.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839