Querybuilder: Find users who are only in "Everyone&quot

security CMC
2

Hi,
What i know is, All users of BO Enterprise will be automatically added to the Everyone group by default.

If you want to really check who are they, You can make use of CMC and navigate to Everone group to see list of all users.

QueryBuilder:
i don’t know straight query but this can be achieved in 2 steps

  1. Get the group memembers SI_ID from query1
select SI_GROUP_MEMBERS from ci_Systemobjects where si_kind in ('UserGroup') and SI_NAME='Everyone'
  1. Get the user names by providing the SI_ID values from the above query
select SI_NAME from ci_Systemobjects where si_kind in ('User') and SI_ID in (12,1)

where 12, 1 are SI_ID’s of user’s from quer1

BOB Downloads :
There is a utility or code to extract complete list of users and the list of groups each user is member of.Check this Bob Downloads.

Thanks
-Satish

forgotUN (BOB member since 2006-12-13)