Export agrnts

[Leonxxx86]

How do I export agents from Genesys? I would like to export non disabled agents only? Thanks

[nonny]

What are you looking to do with that export and what info do you want in it?

Sent from my SM-N9005 using Tapatalk

[Leonxxx86]

export them for a reporting purposes. I just want to know how many active agents in the system. Thanks

[nonny]

If you just want to know how many active just run the query in CME etc and filter on active.

Sent from my SM-N9005 using Tapatalk

[Leonxxx86]

Thanks for your reply, Can you please advise how do I run query in CME? Thanks

[Kubig]

Tools -> Find or "Ctrl + F" (set the filter to list only active users)

[Leonxxx86]

Thanks Kubig, could you please advise how do I export the list of agents to Excel spreadsheet for example?

[nonny]

Sorry I thought you just said you wanted to know the number of active agents.

What do you want to do with Excel?

Sent from my SM-N9005 using Tapatalk

[Kubig]

In this case, just use the Genesys Administrator which allows you to download the export of agents in CSV format. Maybe the GAX will provide the same set of features, but cannot check it yet.

[Leonxxx86]

Thanks Guys, There is no GA configured 
is there any other way to export the agents?

[Kubig]

You can use the CIW, where the output should be in XML format. But, there is a limitation that you cannot filter agents before the export, I guess.

The other way is through the PSDK.

[msh]

You can also look in the cfg_person table in the genesys database.

[Leonxxx86]

Thank you very much Kubig, Just a quick one, how do I run a query in SQL to show the active users only?

[Leonxxx86]

It is ok, I found it. In cfg_person table, I have run a query and added this statement in the end "where state=1" this showed only the active users as state 1 means active and 2 disabled. Thanks for your help.