LDAP_LINK_DRYRUN_EVENTS

Collects the results from LDAP dry run meta-functions:.

Collects the results from LDAP dry run meta-functions:

For detailed instructions on using these meta-functions, see Configuring LDAP link with dry runs.

Column Name Data Type Description
EVENT_TIMESTAMP TIMESTAMP The date and time of an LDAP server and Vertica LDAP Link interaction.
NODE_NAME VARCHAR The clerk node.
SESSION_ID VARCHAR The identification number of the LDAP Link session.
USER_ID INTEGER The unique, system-generated user identification number.
USER_NAME VARCHAR The name of the user for which the information is listed.
TRANSACTION_ID INTEGER The system-generated transaction identification number. Is NULL if a transaction id does not exist.
EVENT_TYPE VARCHAR The result of a dry run.
ENTRY_NAME VARCHAR The name of the object on which the event occurred, if applicable. For example, the event SYNC-STARTED does not use an object.
ROLE_NAME VARCHAR The name of a role.
LDAPURIHASH INTEGER The URI hash number for the LDAP user.
LDAP_URI VARCHAR The URI for the LDAP server.
BIND_DN VARCHAR The Distinguished Name used for the dry run bind.
FILTER_GROUP VARCHAR The group attribute passed to the dry run meta-functions as LDAPLinkFilterGroup.
FILTER_USER VARCHAR The user attribute passed to the dry run meta-functions as LDAPLinkFilterUser.
LINK_SCOPE VARCHAR The DN level to replicate, passed to the dry run meta-functions as LDAPLinkScope.
SEARCH_BASE VARCHAR The DN level from which LDAP Link begins the search, passed to the dry run meta-functions as LDAPLinkSearchBase.
GROUP_MEMBER VARCHAR Identifies the members of an LDAP group, passed to the dry run meta-functions as LDAPLinkGroupMembers.
GROUP_NAME VARCHAR The LDAP field to use when creating a role name in Vertica, passed to the dry run meta-functions as LDAPLinkGroupName.
LDAP_USER_NAME VARCHAR The attribute that identifies individual users, passed to the dry run meta-functions as LDAPLinkUserName.
TLS_REC_CERT VARCHAR The connection policy used for the dry run connection for certificate management. This connection policy is set through the LDAPLink TLS CONFIGURATION.
TLS_CA_CERT VARCHAR The CA certificate used for the dry run connection specified by the LDAPLink TLS CONFIGURATION.