Running the SQL-Statement below against a Automic Database will deliver the following Usergroup information:
.) Clients the Usergroup-Objects can be found in.
.) User-Objects that are part of the Usergroup.
.) First and Last Name of the User that belongs to the User-Object
a.oh_client as Client,
b.oh_name as User_group_object,
a.oh_name as User_object,
USR_FIRSTNAME as Firstname ,
USR_LASTNAME as Lastname
from oh a, oh b, usrg, usr where usr_oh_idnr = a.oh_idnr and
a.oh_idnr = usrg_usr_idnr and b.oh_idnr = usrg_usg_idnr and a.oh_client = b.oh_client order by 1, 2, 3, 4;
The information returned by the Database will look like this:
<Please see attached file for image>
<Please see attached file for image>align="bottom" class="documentation" border="0" alt=".png" src="http://ecmstage.ca.com/KB%20Asset%20Library/000008547_Embeded/.png" width="516" height="241">