Automic Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

help with a SQL query to get list of Users and the Groups they are in

  • 1.  help with a SQL query to get list of Users and the Groups they are in

    Posted May 08, 2017 03:35 AM
    A customer needs help with a SQL query to get list of Users and the Groups they are in.

    The table USGR represents the relation between user and user groups
    The following select give you all users and its user groups

    select a.OH_Client, a.OH_NAME, b.OH_Name 
    from 
    OH a, 
    oh b, 
    USRG
    where 
    a.OH_IDNR = USRG_USR_Idnr and
    b.OH_Idnr = USRG_USG_Idnr
    order by 3


  • 2.  help with a SQL query to get list of Users and the Groups they are in

    Posted May 09, 2017 12:34 AM
    Thanks Christian.  This gave me the result I was looking for.  Would be good if there were standard reporting queries provided in the tool.