Genesys Cloud - Main

I am trying to export all users solely for the purpose of viewing the agents in the system. The intended purpose does not require any relevant data outside of the agent name. Searching through the forums points to the old dashboard and no longer applies. Just want to click all agents, export to a CSV. 

#System/PlatformAdministration

------------------------------
Keith Eggleston
na
------------------------------

Hello @Keith Eggleston.

If you don't need any relevant data, you can use Analytics Workspace > Agent Performance filtering by active users

------------------------------
Arthur Pereira Reinoldes
------------------------------

Arthur 

good ideia hahaha

-

-

Keith 

I recommend you vote for this idea too, this is precisely so that we have the option to export users.

https://genesyscloud.ideas.aha.io/ideas/OP-I-467

------------------------------
Kaio Oliveira
GCP - GCQM - GCS - GCA - GCD - GCO - GPE & GPR - GCWM

PS.: I apologize if there are any mistakes in my English; my primary language is Portuguese-Br.
------------------------------

Hi @Keith Eggleston,

I would also recommend to use Genesys API to export the users. 

Though API, you can even have all the roles and permissions assigned to the users, which facilitate any tasks involving a security or governance clean up.

------------------------------
Diego Pamplona
------------------------------

Olá @Keith Eggleston,

Eu também recomendaria usar a API do Genesys para exportar os usuários. 

Por meio da API, você pode até mesmo atribuir todas as funções e permissões aos usuários, o que facilita quaisquer tarefas que envolvam uma limpeza de segurança ou governança.

------------------------------
MANOEL FERNANDO BRITO DE ALMEIDA
na
------------------------------

Hi Keith,
I recommend using Genesys CLI. With the Command 

gc users list --autopaginate > users_with_roles.json

you get a whole export in one step without pagination.

With an json to excel converter you should get a good result.

------------------------------
Christoph Domaschke
Produktmanager Kunden-Dialog-Center
------------------------------

To add one more way to do it.. If you have Analytics as a Service (A3S) you can query the Snowflake database. Here are queries I use from time to time.

This is my Agents and Division they are in query.

SELECT
  ar.resource_name,
  ar.user_name,
  ar.state,
  d.division_name
FROM
  agent_resources AS ar
  JOIN divisions AS d
    ON ar.division_id = d.division_id
WHERE
  d.division_name ILIKE '<YOUR_DIVISION_HERE>' or d.division_name ILIKE '<YOUR_OTHER_DIVISION_HERE>'
  AND ar.active_flag = 1
//  AND ar.state ILIKE 'active'
ORDER BY
  ar.resource_name;

This is my Agents, Language & ACD Skill + Proficiency query.

select 
    rsf.last_modified,
    ar.resource_name as Agent_Name,
    rs.routing_skill_name as ACD_Skill,
    rsf.skill_proficiency,
    rsf.skill_type,
    d.division_name as division_id,
from A3S_GCD.PUBLIC.RESOURCE_SKILL_FACT rsf
left join A3S_GCD.PUBLIC.AGENT_RESOURCES ar
    on rsf.resource_id = ar.resource_id
left join A3S_GCD.PUBLIC.ROUTING_SKILLS rs
    on rsf.skill_id = rs.routing_skill_id
left join A3S_GCD.PUBLIC.DIVISIONS d
    on ar.division_id = d.division_id

------------------------------
Brad Carroll
Auto Club Group
------------------------------