SQL Statement to get information about Usergroups

Document ID : KB000088481
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:

Symptoms

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

SQL-Statement:

select 

 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;

 

Resolution:

The information returned by the Database will look like this:

.png