Overview

You may need a list of permissions available to groups, meant for users of the CSR portal, for audit or reporting requirements.

Information

Since there is no straightforward way to generate this report from the CSR portal, create a support ticket and share the group names or IDs for which you want this information exported.

<supportagent>

Clients may share either of group names (such as Users, Finance, Contact Center Agent, etc.) or group IDs (numerical values). Follow the steps below to generate this report.

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. Use the client's database.
5. Run the below query, being careful to use either the GroupName or GroupID column depending on which of them is provided.

   use paes_Stream
   
   select Label,GroupName,SGSO.* 
     from SecGroupSecObject SGSO 
     join paes_BillingAdmin..SecObject SO on SGSO.ObjectID=SO.ObjectID
     join SecGroup SG on SGSO.GroupID=SG.GroupID
     where SG.GroupName='<client specified group name>' -- if group name is provided
     -- where SG.GroupID=<client specified groupID> -- if GroupID is provided  

6. Export the results and share them with the client.

</supportagent>