How to identify which users have inactive LDAP status through MFT Command Center and/or Database?
book
Article ID: KB0074484
calendar_today
Updated On:
Products
Versions
TIBCO Managed File Transfer Command Center
All
Description
How to identify which users have inactive LDAP status through CC and/or DB?
Environment
All
Resolution
The field corresponding to "LDAP Status" is present in the "USERS" database table. It is called SendOnlyToUserID. When the user is disabled in LDAP, the next time the user is synced, this field is set to INACTIVE. It has nothing to do with the user existing in an enabled/disabled authenticator.
For the field "SendOnlyToUserID", the value indicates the type of user.
It has 3 parts:
INACTIVE - This user has been removed from an LDAP authenticator or the authenticator has been disabled. An INACTIVE user cannot log in. If this part is missing then the user can log in.
AM, MAILBOX or CFI - AM means the user can use both the File Share and Mailbox features. MAILBOX means the user can only send or receive the email. CFI is an obsolete value. It means the user cannot use any File Share or Mailbox feature.
GUEST, FULL or POWER - The ability to create other users or share files. 3a) GUEST users cannot create any user. They cannot share the file. 3b) FULL users can do everything a GUEST does as well as creating GUEST users. They can share the file. 3c) POWER users can do everything a FULL does as well as creating FULL users.
Below are the valid values: AM GUEST - Can use File Share and Mailbox as a GUEST user. AM FULL - Can use File Share and Mailbox as a FULL user. AM POWER - Can use File Share and Mailbox as a POWER user. MAILBOX GUEST - Can use Mailbox as a GUEST user. Cannot use File Share. MAILBOX FULL - Can use Mailbox as a FULL user. Cannot use File Share. MAILBOX POWER - Can use Mailbox as a POWER user. Cannot use File Share. NONE or NULL - Cannot use the File Share or Mailbox features.
Issue/Introduction
How to identify which users have inactive LDAP status through MFT Command Center and/or Database?