Get list of all access groups an operator belongs to.
I need to get a list of all operators and all the access groups they belong to.
How do I do that? Is there an existing report I can run to get this information?
Ford Motor Company
US
@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]
Updated: 6 Jul 2023 15:56 EDT
Aaseya It Services Pvt Limited
SA
Hello @SUMAN_GUMUDAVELLY,
Based on the above requirement, write a report definition in Pega with the following steps
(1) Add these columns in the Query, screenshot 1
pyUserName
pyUserIdentifier
pyWorkGroup
AAG.pyAccessGroupAdditional
(2)Add Declarative Index Join in the data access tab, please find the screenshot 2
(3) Add the filter condition, AAG.pyAccessGroupAdditional is not null, please find the screenshot 3.
Now the report is ready to pull the list of operators with all AccessGroups, if any specific AccessGroup/Operator is required, add the filter conditions in the same report.
Hope you have got the answer, find the document attached for the reference.
Regards,
Sadiq Shaik,
Senior Consultant,
Aaseya IT Services Pvt Ltd, KSA.
Rulesstack Private Limited
IN
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
CIBC
CA
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;