List of user ids based on Alias/Authentication type in BO 4.0

[Former Member]

Hi Gurus,

We have a request where in we need to get the list of users based on the Alias or Authentication type.

To be more specific we need to find the list of users who have Enterprise Alias. It would be a tedious task to go to each user and find out as we have more than 10000 users. Is their an easier way to get the list?

We are in BO 4.0. Please let me know if any further details is required to get a solution for this.

Thanks,

Arjun

[Former Member · Accepted solution]

TRy using query builder,

regardes

ROgerio

[holger_brasch]

Hi, if you are looking for list of user having ONLY enterprise alias and no other alias assigned,
then below query should do it for query builder:

SELECT top 100000 SI_NAME, SI_DESCRIPTION, SI_ID, SI_ALIASES, SI_GROUP_MEMBERS

FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER'  and SI_ALIASES.SI_TOTAL=1

If you somehow need to further process that list you might need to include it in SDK script.

I hope that helps, Holger

[former_member833983]

This would not help! Because it will give you user list where SI_TOTAL=1! If the user has only AD alias, in that case as well SI_TOTAL=1.