LDAP Query Data Model

Connection String Options

  1. Auth Mechanism
  2. Auto Cache
  3. Base DN
  4. Cache Connection
  5. Cache Driver
  6. Cache Location
  7. Cache Metadata
  8. Connect On Open
  9. Firewall Password
  10. Firewall Port
  11. Firewall Server
  12. Firewall Type
  13. Firewall User
  14. Follow Referrals
  15. Location
  16. Logfile
  17. Max Log File Size
  18. Offline
  19. Other
  20. Password
  21. Port
  22. Proxy Auth Scheme
  23. Proxy Auto Detect
  24. Proxy Password
  25. Proxy Port
  26. Proxy Server
  27. Proxy SSL Type
  28. Proxy User
  29. Pseudo Columns
  30. Query Cache
  31. Readonly
  32. RTK
  33. Scope
  34. Server
  35. SSL Server Cert
  36. Support Enhanced SQL
  37. Tables
  38. Timeout
  39. Use Default DC
  40. User
  41. Verbosity
  42. Version

Auth Mechanism

Data Type

string

Default Value

"SIMPLE"

Remarks

By default, AuthMechanism is SIMPLE, and default plaintext authentication is used to log in to the server. If AuthMechanism is set to DIGESTMD5, the more secure DIGEST-MD5 authentication is used. If AuthMechanism is set to NEGOTIATE, NTLM/Negotiate authentication will be used.

  • SIMPLE
  • DIGESTMD5
  • NEGOTIATE

 

 

Auto Cache

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically caches the results of SELECT queries to a cache specified by the CacheLocation option. CacheLocation defines the path to a simple, file-based cache.

The following sections detail how AutoCache works and its limitations.

 

How AutoCache Works

 

When you execute a SELECT statement with AutoCache set, the driver executes the query to the remote data and persists the results; rows that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it.

Non-queries (such as UPDATE/INSERT/DELETE statements) are executed to the remote data as well; these statements will not modify the data in the cache at all, regardless of the value set for AutoCache.

To query the cached data, append #CACHE to the table name. For example:

SELECT * FROM [User#CACHE]
When to Use AutoCache

 

In scenarios that require lightweight caching, AutoCache simplifies configuration. For example, it can be effective at persisting a report. When you are offline, you can still access your local copy of the report by setting Offline to true. See Caching: Best Practices for several more examples of using these properties together.

The AutoCache functionality is more limited for multiple reports on the same table or tables. AutoCache persists result set metadata, not table metadata, so you would need to retrieve the table metadata first. You can use CacheMetadata to retrieve metadata for the complete data model on the first connection, or CACHE Statements to retrieve metadata for individual tables.

When Not to Use AutoCache

 

In the following scenarios, consider the alternatives listed below:

  • When you need a managed solution for maintaining cached data: The main limitation of AutoCache is the extent of its automation. AutoCache is most useful as a simple way to implicitly cache data for later offline use; however, maintaining and querying the cache still must be explicit. CACHE Statements provide a way to accomplish this explicitly through SQL.

  • When you need to work with an RDBMS: AutoCache can only be used with the default database. If you need to support more concurrent writes or integrate with existing infrastructure, specify an alternative database driver with CacheConnection and CacheDriver.

 

 

Base DN

Data Type

string

Default Value

""

Remarks

Specifying a base DN may greatly improve performance when returning entries for large servers by limiting the number of entries that need to be examined.

 

Cache Connection

Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheConnection defines the connection properties necessary to connect to the cache database.

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'

 

 

 

Cache Driver

Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for. The driver has been tested with SQL Server, Derby and Java DB, MySQL, Oracle, and SQLite.

The cache database is determined based on CacheDriver and the CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data. The example below caches to SQL Server:

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'
Note that the driver JAR must be specified on the classpath.

 

 

Cache Location

Data Type

string

Default Value

""

Remarks

If AutoCache is set but the cache location is not specified, CacheLocation defaults to the cache folder on the directory specified by the Location setting.

The CacheLocation is a simple, file-based cache. See the CacheConnection and CacheDriver properties to cache to other databases.

 

Cache Metadata

Data Type

bool

Default Value

false

Remarks

The cache.db file will be created in the location specified by the CacheConnection or if that is not set, the CacheLocation.

 

Connect On Open

Data Type

bool

Default Value

true

Remarks

When set to 'true', a connection will be made to LDAP when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to LDAP and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).

 

Firewall Password

Data Type

string

Default Value

""

Remarks

If FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate to the given firewall.

 

Firewall Port

Data Type

string

Default Value

""

Remarks

Note that the driver sets the FirewallPort to the default port associated with the specified FirewallType. See the description of the FirewallType option for details.

 

Firewall Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding IP address.

 

Firewall Type

Data Type

string

Default Value

"NONE"

Remarks

The applicable values are:

 

   
Firewall Type Default FirewallPort
TUNNEL 80
SOCKS4 1080
SOCKS5 1080

 

 

Firewall User

Data Type

string

Default Value

""

Remarks

If the FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate against the firewall.

 

Follow Referrals

Data Type

bool

Default Value

false

Remarks

When following referrals, you will only be able to return data from the referral servers. INSERT/UPDATE/DELETE will not be available without updating the connection string to connect directly to that server.

 

Location

Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.

 

Logfile

Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.

 

Max Log File Size

Data Type

string

Default Value

""

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. There is no limit by default. Values lower than 100kB will use 100kB as the value instead.

 

Offline

Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.

 

Other

Data Type

string

Default Value

""

Remarks

The Other property is a semicolon-separated list of name-value pairs used in connection parameters specific to a data source.

Caching Configuration

 

   
CachePartial=True Caches only a subset of columns, which you can specify in your query.
QueryPassthrough=True Passes the specified query to the cache database instead of using the SQL parser of the driver.

 

Integration and Formatting

 

   
SupportAccessLinkedMode In Access' linked mode, it is generally a good idea to always use a cache as most data sources do not support multiple Id queries. However if you want to use the driver in Access but not in linked mode, this property must be set to False to avoid using a cache of a SELECT * query for the given table.
ConvertDateTimesToGMT Whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename Records the underlying socket data transfer to the specified file.
ClientCulture This property can be used to specify the format of data (e.g., currency values) that is accepted by the client application. This property can be used when the client application does not support the machine's culture settings. For example, Microsoft Access requires 'en-US'.
Culture This setting can be used to specify culture settings that determine how the driver interprets certain data types that are passed into the driver. For example, setting Culture='de-DE' will output German formats even on an American machine.

 

 

Password

Data Type

string

Default Value

""

Remarks

Together with User, this field is used to authenticate against the LDAP server.

 

 

Port

Data Type

string

Default Value

"389"

Remarks

The port the LDAP server is running on. Together with Server, this property is used to specify the LDAP server.

 

Proxy Auth Scheme

Data Type

string

Default Value

"BASIC"

Remarks

This value may be BASIC, DIGEST, NONE, NTLM, NEGOTIATE or PROPRIETARY.

 

Proxy Auto Detect

Data Type

bool

Default Value

true

Remarks

This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.

 

Proxy Password

Data Type

string

Default Value

""

Remarks

If the ProxyServer is specified, the ProxyUser and ProxyPassword properties are used to connect and authenticate against the firewall.

 

Proxy Port

Data Type

string

Default Value

"80"

Remarks

See the description of the ProxyServer field for details.

 

Proxy Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding address.

 

Proxy SSL Type

Data Type

string

Default Value

"AUTO"

Remarks

This value may be AUTO, ALWAYS, NEVER, or TUNNEL.

 

Proxy User

Data Type

string

Default Value

""

Remarks

If a ProxyServer is specified, the ProxyUser and ProxyPassword options are used to connect and authenticate against the firewall.

 

Pseudo Columns

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".

 

Query Cache

Data Type

string

Default Value

""

Remarks

The QueryCache allows you to cache the results of a query in-memory and use them until the cache expires. Setting the QueryCache can improve performance if the same or similar (see below) queries are executed often. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

The cache manager for QueryCache will not only use the results in the cache for exactly the same query, but also for queries that represent a subset of data in the cached query. For example, in the following queries, the cache created while executing Query A will be used to obtain the results for both Query B and Query C.

SELECT * from Account; // Query A
SELECT * from Account WHERE Name LIKE '%John'; // Query B
SELECT Id, Name from from Account LIMIT 10; // Query C

 

Setting the QueryCache to zero disables in-memory caching.

 

Readonly

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.

 

RTK

Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.

 

Scope

Data Type

string

Default Value

"WHOLESUBTREE"

Remarks

Whether to limit the scope of the search to the whole subtree (BaseDN and all of its descendants), a single level (BaseDN and its direct descendants), or the base object (BaseDN only). Limiting scope can greatly improve the search performance.

  • WholeSubtree
  • SingleLevel
  • BaseObject

 

 

Server

Data Type

string

Default Value

""

Remarks

Note: This does not need to include the LDAP:\\ portion, only the server domain name or IP.

 

SSL Server Cert

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected. This can take the form of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint. If not specified, any trusted certificate will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).

 

Support Enhanced SQL

Data Type

bool

Default Value

true

Remarks

Use QueryCache to cache in memory for a given time in seconds or to disable in-memory caching.

 

Tables

Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

 

Timeout

Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.

 

Use Default DC

Data Type

bool

Default Value

false

Remarks

Used to connect to the default Domain Controller and authenticate using the current user credentials.

 

User

Data Type

string

Default Value

""

Remarks

Together with Password, this field is used to authenticate against the LDAP server.

 

 

Verbosity

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

 

   
1 Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2 Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.
3 Setting Verbosity to 3 will additionally log the body of the HTTP requests.
4 Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5 Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.

 

Version

Data Type

string

Default Value

"2"

Remarks

Valid options are 2 and 3 for LDAP versions 2 and 3.




 

Tables

  1. Group
  2. OrganizationalPerson
  3. Person
  4. Top
  5. User

Group

Create, update, delete, and query Group entries in LDAP.

 

Columns

 

 

 

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

The index of the row, when 'splitDataByRow' is set for a column, combined with the full distinguished name.

DN String True    

The full distinguished name.

RDN String False    

The relative distinguished name.

BaseDN String True    

The base distinguished name.

GroupType String False   delimitedData

The required attribute GroupType for the Group object class.

ObjectClass String False   splitDataByRow

The object class of the entity.

Member String False   delimitedData

The optional attribute Member for the Group object class.

NTGroupMembers String False   delimitedData

The optional attribute NTGroupMembers for the Group object class.

OperatorCount String False   delimitedData

The optional attribute OperatorCount for the Group object class.

AdminCount String False   delimitedData

The optional attribute AdminCount for the Group object class.

GroupAttributes String False   delimitedData

The optional attribute GroupAttributes for the Group object class.

GroupMembershipSAM String False   delimitedData

The optional attribute GroupMembershipSAM for the Group object class.

ControlAccessRights String False   delimitedData

The optional attribute ControlAccessRights for the Group object class.

DesktopProfile String False   delimitedData

The optional attribute DesktopProfile for the Group object class.

NonSecurityMember String False   delimitedData

The optional attribute NonSecurityMember for the Group object class.

ManagedBy String False   delimitedData

The optional attribute ManagedBy for the Group object class.

PrimaryGroupToken String False   delimitedData

The optional attribute PrimaryGroupToken for the Group object class.

Mail String False   delimitedData

The optional attribute Mail for the Group object class.

 

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
* String

Passes through all inputs.

 

 

 

OrganizationalPerson

Create, update, delete, and query OrganizationalPerson entries in LDAP.

 

Columns

 

 

 

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

The index of the row, when 'splitDataByRow' is set for a column, combined with the full distinguished name.

DN String True    

The full distinguished name.

RDN String False    

The relative distinguished name.

BaseDN String True    

The base distinguished name.

ObjectClass String False   delimitedData

The object class of the entity.

SN String False   delimitedData

The surname of the person.

CN String False   delimitedData

the common name of the person.

UserPassword String False   delimitedData

The user password of the person.

TelephoneNumber String False   delimitedData

The telephone number of the person.

SeeAlso String False   delimitedData

The see-also distinguished name of the person.

Description String False   delimitedData

The description of the person.

Title String False   delimitedData

The optional attribute Title for the OrganizationalPerson object class.

X121Address String False   delimitedData

The optional attribute X121Address for the OrganizationalPerson object class.

RegisteredAddress String False   delimitedData

The optional attribute RegisteredAddress for the OrganizationalPerson object class.

DestinationIndicator String False   delimitedData

The optional attribute DestinationIndicator for the OrganizationalPerson object class.

PreferredDeliveryMethod String False   delimitedData

The optional attribute PreferredDeliveryMethod for the OrganizationalPerson object class.

TelexNumber String False   delimitedData

The optional attribute TelexNumber for the OrganizationalPerson object class.

TeletexTerminalIdentifier String False   delimitedData

The optional attribute TeletexTerminalIdentifier for the OrganizationalPerson object class.

InternationaliSDNNumber String False   delimitedData

The optional attribute InternationaliSDNNumber for the OrganizationalPerson object class.

FacsimileTelephoneNumber String False   delimitedData

The optional attribute FacsimileTelephoneNumber for the OrganizationalPerson object class.

Street String False   delimitedData

The optional attribute Street for the OrganizationalPerson object class.

PostOfficeBox String False   delimitedData

The optional attribute PostOfficeBox for the OrganizationalPerson object class.

PostalCode String False   delimitedData

The optional attribute PostalCode for the OrganizationalPerson object class.

PostalAddress String False   delimitedData

The optional attribute PostalAddress for the OrganizationalPerson object class.

PhysicalDeliveryOfficeName String False   delimitedData

The optional attribute PhysicalDeliveryOfficeName for the OrganizationalPerson object class.

OU String False   delimitedData

The optional attribute OU for the OrganizationalPerson object class.

ST String False   delimitedData

The optional attribute ST for the OrganizationalPerson object class.

L String False   delimitedData

The optional attribute L for the OrganizationalPerson object class.

 

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
* String

Passes through all inputs.

 

 

 

Person

Create, update, delete, and query Person entries in LDAP.

 

Columns

 

 

 

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

The index of the row, when 'splitDataByRow' is set for a column, combined with the full distinguished name.

DN String True    

The full distinguished name.

RDN String False    

The relative distinguished name.

BaseDN String True    

The base distinguished name.

ObjectClass_1 String False   splitDataByCol

The object class of the entry.

ObjectClass_2 String False   splitDataByCol

The object class of the entry.

ObjectClass_3 String False   splitDataByCol

The object class of the entry.

ObjectClass_4 String False   splitDataByCol

The object class of the entry.

SN String False   delimitedData

The surname of the person.

CN String False   delimitedData

The common name of the person.

UserPassword String False   delimitedData

The user password of the person.

TelephoneNumber String False   delimitedData

The telephone number of the person.

SeeAlso String False   splitDataByRow

The see-also distinguished name of the person.

Description String False   delimitedData

The description of the person.

 

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
* String

Passes through all inputs.

 

 

 

Top

Create, update, delete, and query Top entries in LDAP. (All object classes inherit Top, so all object classes will be returned.)

 

Columns

 

 

 

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

The index of the row, when 'splitDataByRow' is set for a column, combined with the full distinguished name.

DN String True    

The full distinguished name.

RDN String False    

The relative distinguished name.

BaseDN String True    

The base distinguished name.

ObjectClass String False   delimitedData

The object class of the entity.

SN String False   delimitedData

The required attribute SN for the User object class.

CN String False   delimitedData

The required attribute CN for the User object class.

GroupType String False   delimitedData

The required attribute GroupType for the Group object class.

DC String False   delimitedData

The attribute DC for the Domain object class.

 

 

 

User

Create, update, delete, and query User entries in LDAP.

 

Columns

 

 

 

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

The index of the row, when 'splitDataByRow' is set for a column, combined with the full distinguished name.

DN String True    

The full distinguished name.

RDN String False    

The relative distinguished name.

BaseDN String True    

The base distinguished name.

ObjectClass String False   delimitedData

The object class of the entity.

SN String False   delimitedData

The required attribute SN for the User object class.

CN String False   delimitedData

The required attribute CN for the User object class.

UserPassword String False   delimitedData

The optional attribute UserPassword for the User object class.

TelephoneNumber String False   delimitedData

The optional attribute TelephoneNumber for the User object class.

SeeAlso String False   delimitedData

The optional attribute SeeAlso for the User object class.

Description String False   delimitedData

The optional attribute Description for the User object class.

Title String False   delimitedData

The optional attribute Title for the User object class.

X121Address String False   delimitedData

The optional attribute X121Address for the User object class.

RegisteredAddress String False   delimitedData

The optional attribute RegisteredAddress for the User object class.

DestinationIndicator String False   delimitedData

The optional attribute DestinationIndicator for the User object class.

PreferredDeliveryMethod String False   delimitedData

The optional attribute PreferredDeliveryMethod for the User object class.

TelexNumber String False   delimitedData

The optional attribute TelexNumber for the User object class.

TeletexTerminalIdentifier String False   delimitedData

The optional attribute TeletexTerminalIdentifier for the User object class.

InternationaliSDNNumber String False   delimitedData

The optional attribute InternationaliSDNNumber for the User object class.

FacsimileTelephoneNumber String False   delimitedData

The optional attribute FacsimileTelephoneNumber for the User object class.

Street String False   delimitedData

The optional attribute Street for the User object class.

PostOfficeBox String False   delimitedData

The optional attribute PostOfficeBox for the User object class.

PostalCode String False   delimitedData

The optional attribute PostalCode for the User object class.

PostalAddress String False   delimitedData

The optional attribute PostalAddress for the User object class.

PhysicalDeliveryOfficeName String False   delimitedData

The optional attribute PhysicalDeliveryOfficeName for the User object class.

OU String False   delimitedData

The optional attribute OU for the User object class.

ST String False   delimitedData

The optional attribute ST for the User object class.

L String False   delimitedData

The optional attribute L for the User object class.

UserCertificate String False   delimitedData

The optional attribute UserCertificate for the User object class.

NetworkAddress String False   delimitedData

The optional attribute NetworkAddress for the User object class.

UserAccountControl String False   delimitedData

The optional attribute UserAccountControl for the User object class.

BadPwdCount String False   delimitedData

The optional attribute BadPwdCount for the User object class.

CodePage String False   delimitedData

The optional attribute CodePage for the User object class.

HomeDirectory String False   delimitedData

The optional attribute HomeDirectory for the User object class.

HomeDrive String False   delimitedData

The optional attribute HomeDrive for the User object class.

BadPasswordTime String False   delimitedData

The optional attribute BadPasswordTime for the User object class.

LastLogoff String False   delimitedData

The optional attribute LastLogoff for the User object class.

LastLogon String False   delimitedData

The optional attribute LastLogon for the User object class.

DBCSPwd String False   delimitedData

The optional attribute DBCSPwd for the User object class.

LocaleID String False   delimitedData

The optional attribute LocaleId for the User object class.

ScriptPath String False   delimitedData

The optional attribute ScriptPath for the User object class.

LogonHours String False   delimitedData

The optional attribute LogonHours for the User object class.

LogonWorkstation String False   delimitedData

The optional attribute LogonWorkstation for the User object class.

MaxStorage String False   delimitedData

The optional attribute MaxStorage for the User object class.

UserWorkstations String False   delimitedData

The optional attribute UserWorkstations for the User object class.

UnicodePwd String False   delimitedData

The optional attribute UnicodePwd for the User object class.

OtherLoginWorkstations String False   delimitedData

The optional attribute OtherLoginWorkstations for the User object class.

NtPwdHistory String False   delimitedData

The optional attribute NtPwdHistory for the User object class.

PwdLastSet String False   delimitedData

The optional attribute PwdLastSet for the User object class.

PreferredOU String False   delimitedData

The optional attribute PreferredOU for the User object class.

PrimaryGroupID String False   delimitedData

The optional attribute PrimaryGroupId for the User object class.

UserParameters String False   delimitedData

The optional attribute UserParameters for the User object class.

ProfilePath String False   delimitedData

The optional attribute ProfilePath for the User object class.

OperatorCount String False   delimitedData

The optional attribute OperatorCount for the User object class.

AdminCount String False   delimitedData

The optional attribute AdminCount for the User object class.

AccountExpires String False   delimitedData

The optional attribute AccountExpires for the User object class.

LmPwdHistory String False   delimitedData

The optional attribute LmPwdHistory for the User object class.

GroupMembershipSAM String False   delimitedData

The optional attribute GroupMembershipSAM for the User object class.

LogonCount String False   delimitedData

The optional attribute LogonCount for the User object class.

ControlAccessRights String False   delimitedData

The optional attribute ControlAccessRights for the User object class.

DefaultClassStore String False   delimitedData

The optional attribute DefaultClassStore for the User object class.

GroupsToIgnore String False   delimitedData

The optional attribute GroupsToIgnore for the User object class.

GroupPriority String False   delimitedData

The optional attribute GroupPriority for the User object class.

DesktopProfile String False   delimitedData

The optional attribute DesktopProfile for the User object class.

DynamicLDAPServer String False   delimitedData

The optional attribute DynamicLDAPServer for the User object class.

UserPrincipalName String False   delimitedData

The optional attribute UserPrincipalName for the User object class.

LockoutTime String False   delimitedData

The optional attribute LockoutTime for the User object class.

UserSharedFolder String False   delimitedData

The optional attribute UserSharedFolder for the User object class.

UserSharedFolderOther String False   delimitedData

The optional attribute UserSharedFolderOther for the User object class.

ServicePrincipalName String False   delimitedData

The optional attribute ServicePrincipalName for the User object class.

ACSPolicyName String False   delimitedData

The optional attribute ACSPolicyName for the User object class.

TerminalServer String False   delimitedData

The optional attribute TerminalServer for the User object class.

MSMQSignCertificates String False   delimitedData

The optional attribute MSMQSignCertificates for the User object class.

MSMQDigests String False   delimitedData

The optional attribute MSMQDigests for the User object class.

MSMQDigestsMig String False   delimitedData

The optional attribute MSMQDigestsMig for the User object class.

MSMQSignCertificatesMig String False   delimitedData

The optional attribute MSMQSignCertificatesMig for the User object class.

MsNPAllowDialin String False   delimitedData

The optional attribute MsNPAllowDialin for the User object class.

MsNPCallingStationID String False   delimitedData

The optional attribute MsNPCallingStationId for the User object class.

MsNPSavedCallingStationID String False   delimitedData

The optional attribute MsNPSavedCallingStationId for the User object class.

MsRADIUSCallbackNumber String False   delimitedData

The optional attribute MsRADIUSCallbackNumber for the User object class.

MsRADIUSFramedIPAddress String False   delimitedData

The optional attribute MsRADIUSFramedIPAddress for the User object class.

MsRADIUSFramedRoute String False   delimitedData

The optional attribute MsRADIUSFramedRoute for the User object class.

MsRADIUSServiceType String False   delimitedData

The optional attribute MsRADIUSServiceType for the User object class.

MsRASSavedCallbackNumber String False   delimitedData

The optional attribute MsRASSavedCallbackNumber for the User object class.

MsRASSavedFramedIPAddress String False   delimitedData

The optional attribute MsRASSavedFramedIPAddress for the User object class.

MsRASSavedFramedRoute String False   delimitedData

The optional attribute MsRASSavedFramedRoute for the User object class.

MS-DS-CreatorSID String False   delimitedData

The optional attribute MS-DS-CreatorSID for the User object class.

 

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
* String

Passes through all inputs.