@lisar179  Either you can write a Report Definition or use below SQL to find the list of OperatorID's and their access groups by joining Operator table and Index table for Operators

SELECT DISTINCT [DatabaseName].[PegaDATA].[pr_index_operators].pyLabel As 'OperatorID',pyAccessGroupAdditional As 'Access Group'
FROM  [DatabaseName].[PegaDATA].[pr_index_operators]
FULL OUTER JOIN [DatabaseName].[PegaDATA].[pr_operators]
ON  [DatabaseName].[PegaDATA].[pr_index_operators].pyLabel = [DatabaseName].[PegaDATA].[pr_operators].[pyUserIdentifier]

Hi @lisar179,

You can create a report definition to fetch the list of all operators and all the access groups they belong to. You can join the Data-Admin-Operator-ID and Index-Operator tables to get a list of operators and different access group users associated with The pyAccessGroupAdditional property in the Index-Operator table that holds the access group name.

Please go through the below link for a better understanding 

https://support.pega.com/question/operator-multiple-accessgroups

Regards,

Mohd Qizer Uddin

@lisar179

You can run this SQL 

select o.pyuseridentifier, o.pyusername,i.pyaccessgroupadditional

from data.PR_OPERATORS o,data.PR_INDEX_OPERATORS i

where o.pyoperatorisdeactivated='false'

and o.pyuseridentifier=i.pylabel(+)

order by o.pyuseridentifier,i.pyaccessgroupadditional;