2.22 NC_LDAPImportTask Table

The NC_LDAPImportTask table contains information about LDAP import tasks..

Column

Key

Type

Null

Description

ZUID

PK, FK

binary(16)

No

An internal ID number used as a primary key.

LdapServer

nvarchar(128)

The name of the LDAP server.

LdapPort

nvarchar(8)

The port used to connect to the LDAP server.

LdapBaseDn

nvarchar(256)

The base DN used when searching the LDAP server.

UseSSL

tinyint

 

1 if an SSL connection is to be used when connecting to the LDAP server, else 0.

LdapSearchFilter

nvarchar(255)

 

The search filter that is used when searching the LDAP server.

PersistCredentials

tinyint

1 if credentials are saved for future task execution, else 0.

HasCredentials

 

tinyint

 

1 if credentials are available for this task, else 0.

CredentialServerUID

FK

binary(16)

 

ID used to identify the credential server.

LastCredentialUpdate

 

datetime

 

Date when credentials were last updated.

RunningStatus

 

nvarchar(32)

 

The current status of the running LDAP import task.

LdapSourceName

 

nvarchar(128)

 

The LDAP source name for this import task.

LastStartTime

 

datetime

 

The last time the import task was started.

LastFinishTime

 

datetime

 

The completion time for the last time this task ran.

LdapContexts

 

ntext

 

The LDAP context for this task.

LdapServerCert

 

ntext

 

The certificate used to connect to the LDAP server.

Packet

 

ntext

 

The credentials of the LDAP directory.