How to get a list of All users and groups they belong to

system · July 23, 2015, 2:33pm

Hello,

What query can I run to extract Users and the groups they belong to?

I am trying this query, and it only shows me si_name and si_userfullname

select si_userfullname,si_name, si_usergroups from ci_systemobjects where children(“si_name = ‘usergroup-user’”, “si_name like ‘%Group’”)

sapaa (BOB member since 2014-02-21)

system · July 23, 2015, 2:51pm

Hi,

This utility can be helpful:

Marek Chladny (BOB member since 2003-11-27)