Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2015 at 09:18 AM

    TRy using query builder,

    regardes

    ROgerio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2016 at 02:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded