Overview

If there is an audit-related requirement or need a list of users who can access the CSR portal to assess the impact of any migration or technical enhancement, you need to create a support ticket with a few details.

Information

You can either request a full export of all active users, or you can send specific UserIDs for whom information is needed. Specific UserIDs can be found from the CSR portal by navigating to Administration Menu > Security > User Setup and searching for a user by any of the provided options, and noting down the value of the UserID parameter in the URL of the user detail page.

Create a support ticket mentioning any specific UserIDs as collected above or just mention all users, and support will help you with this.

<supportagent>

The query for exporting this information is as below

use <client specific database>

Select 
    SU.UserID,
    SU.ActiveFlag,
    Concat(SU.FirstName, ' ',SU.LastName)[User Name]
    , SU.Email
    , SG.GroupID
    , SG.GroupName
    , SG.GroupDescription,
    Case when Su.Activeflag=1 then 'Active'
    else 'Not Active' end as [Status]
From SecUser SU
Left Join SecGroupSecUser SGSU on SU.UserID = SGSU.UserID
Left Join SecGroup SG on SG.GroupID = SGSU.GroupID
Where 1=1
Order by SU.UserID

For a specific set of UserIDs if mentioned by the client, update the Where clause above with a condition such as Where SU.UserID in (<client-specified UserIDs>)
</supportagent>