User table email address filtering.

Annie10
Tera Contributor

Hello,

Currently, there are many users in our company with multiple email address.  For example from the below screenshot. Could we filter the email address to show only ONE email address for all users?   Thanks 

 

Annie10_0-1695228397881.png

 

 

 

18 REPLIES 18

You're most welcome.
Of course that would be the desired thing to do and falls under the suggested "data clean-up" category.

Filtering out unwanted users in the Transform Map, or even in the Data Source in the LDAP query - if the import uses LDAP queries - would be a good solution.

But doesn't that contradict the statement "users need multiple accounts with multiple e-mails for their day-to-day tasks"?

Or are the multiple accounts only needed outside SN?

Annie10
Tera Contributor

@-O- 

Multiple accounts only needed outside SN.  Could you please provide guidance where I should be looking and make changes in SN, because I'm totally lost.  Thank you again.

You're welcome 🙂

 

I'd go and check the LDAP OU Definitions.

Type ldap_ou_config.list into the navigator filter and hit the Enter key:

3.jpg

 

You will hopefully get the list of LDAP queries:
4.jpg

Identifying and modifying the relevant OU definition, probably with the help of an AD person, can filter down the imported users to the correct set.

 

But you will also need a mechanism to flag users imported and when, so that you can distinguish stale records from live ones, so that stale user accounts could be de-activated (in SN).

If such a mechanism is currently not in place, a quick duck-tape solution could be to manually filter users to those not logged in and not imported fot a while an de-activating those using the "Update All" functionality on a regular bases:

5.jpg

Of course it may be that it is not Data Sources and LDAP query that is importing users, but some custom mechanism, but that needs to be identified as part of on "on-site" investigation.

 

Annie10
Tera Contributor

Good morning @-O-  and everyone,

 

These configurations are all new to me. Please allow me some time to digest and implement them correctly to ensure I don't make any mistakes. Hopefully, you will continue to provide assistance if there are additional questions. Once again, we sincerely thank you.

 

Of course, take your time, the community will remain here to help 🙂

And you're most welcome.