on 07-02-2018 3:24 PM
Dear All,
I need the list of BO users and the User Groups to which the users are part of.
Can anyone please help me with the query that i should execute in Query builder to get the user and the group.
I am executing the below query but separately.But not sure how to find the relation between the user and the user group.
Query for users:
Select SI_NAME, SI_USERFULLNAME, SI_ID, SI_NAMEDUSER From CI_SYSTEMOBJECTS Where SI_KIND='User' Order by SI_NAME
- Query for user groups:
Select SI_ID, SI_NAME, SI_REL_USERGROUPS, SI_USERGROUPS, SI_GROUP_MEMBERS, SI_SUBGROUPS from CI_SYSTEMOBJECTS where SI_KIND = 'UserGroup' order by SI_NAME
Thanks
Faizan
Try this
select si_name from ci_systemobjects where children ("si_name = 'usergroup-user'", "si_name = '<ENTER GROUP NAME HERE>'")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jawahar,
I need user Id ,User email id,User group from the query.I am executing the below query not sure how to frame the query to get the third column "Group".Can you please help me out in that.
select si_name ,SI_EMAIL_ADDRESS from ci_systemobjects where children ("si_name = 'usergroup-user'", "si_name = 'Administrators'")
cannot get user and user group details using 1 query.
you have to write SDK script for this. (if you have rights to pull this info from query builder, same can be achieved using script with same credentials)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check attached link for download users/groups
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.