SQL Statement to get information about Usergroups

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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;

 

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

The information returned by the Database will look like this:

<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">