Email Address list is empty for TIBCO Spotfire Automation Services 'Send Email' task

Email Address list is empty for TIBCO Spotfire Automation Services 'Send Email' task

In Automation Services Job Builder > Send Email Task, there is an option to select email addresses from the company directory. But this Select option is only available if there is an LDAP directory configured.
The default search expression to find the users in Send Email task of TIBCO Spotfire Automation Services Job Builder considers expression is:

(&(objectCategory=person)(displayname=*{0}*)(homemdb=*) (!(userAccountControl:1.2.840.113556.1.4.803:=2)))

where {0} is replaced by the text entered by the user, and must not be removed. These expressions are LDAP search filters.

So if user name is not appearing in search results, check in an LDAP browser tool like Softerra LDAP Broswer (see related KB) whether those user names have homeMDB and objectCategory attributes setup and visible because if any of the two attributes are missing for those users then their email addresses would not appear.

If the username does not have a homeMDB attribute, the search expression can be altered like below where users member of either of specific groups are only considered. “|” is used for OR condition between member groups. For example:

(&(objectCategory=person)(displayname=*{0}*)(|(memberOf=CN=Spotfire1,OU=Support,DC=tibco,DC=com)(memberOf=CN=Spotfire2,OU=Distribution Groups,DC=tibco,DC=com)))

If all users present in that company needs to be considered, search expression like below can be used. For example:

(&(objectCategory=person)(displayname=*{0}*)(company=TIBCO))

More examples for creating LDAP search filters are provided in References.

Once the search expression is created, follow below steps in TIBCO Spotfire Analyst:

1. Login to TIBCO Spotfire Analyst client with Spotfire Admin privilege
2. Go to Tools > Administration Manager
3. Select Preference tab
4. Select 'Everyone' group (or desired group)
5. In the right hand side pane, select:  Automation Services > Send Email > SearchExpression
6. Here enter the customized search expression that allows user to search the LDAP
7. After this, close the TIBCO Spotfire Analyst client and open it again to ensure the changes made are active
8. Now you can search for users by their displayname in Send Email task.

Note: When searching user with display name, you can use complete display name of the user present in the external directory ("Mary") or a substring of the beginning letters ("Ma"). Doc: Send Email 

• https://docs.tibco.com/pub/sfire_autsvcs/7.11.0/doc/html/TIB_sfire_autsvcs_7.11.0_UserGuide/GUID-4BAA0BE3-249C-4CD8-B791-C5021788CCF4.html

Doc: Configuring LDAP

• https://docs.tibco.com/pub/spotfire_server/7.11.1/doc/html/TIB_sfire_server_tsas_admin_help/GUID-46156A14-EBB9-4CB4-9F5B-F57BB99D58F0.html

KB: 000035346 How to create LDIF File of a directory object for troubleshooting LDAP User Directory and Authentication issues

• https://support.tibco.com/s/article/How-to-create-LDIF-File-of-a-directory-object-for-troubleshooting-LDAP-User-Directory-and-Authentication-issues

External: LDAP String Representation of Search Filters Specification

• https://tools.ietf.org/html/rfc4515

External: LDAP Search Filter Syntax

• https://docs.microsoft.com/en-us/windows/desktop/adsi/search-filter-syntax

External: How to write LDAP search filters

• https://confluence.atlassian.com/kb/how-to-write-ldap-search-filters-792496933.html