Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Leonxxx86 on March 02, 2016, 03:40:42 AM

Title: Export agrnts
Post by: Leonxxx86 on March 02, 2016, 03:40:42 AM

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

Title: Re: Export agrnts
Post by: nonny on March 02, 2016, 08:32:29 AM

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

Sent from my SM-N9005 using Tapatalk

Title: Re: Export agrnts
Post by: Leonxxx86 on March 03, 2016, 10:09:46 PM

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

Title: Re: Export agrnts
Post by: nonny on March 04, 2016, 09:01:34 AM

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

Title: Re: Export agrnts
Post by: Leonxxx86 on March 06, 2016, 11:04:28 PM

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

Title: Re: Export agrnts
Post by: Kubig on March 07, 2016, 08:48:49 AM

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

Title: Re: Export agrnts
Post by: Leonxxx86 on March 08, 2016, 01:33:50 AM

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

Title: Re: Export agrnts
Post by: nonny on March 08, 2016, 07:28:16 AM

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

Title: Re: Export agrnts
Post by: Kubig on March 08, 2016, 08:39:53 AM

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.

Title: Re: Export agrnts
Post by: Leonxxx86 on March 09, 2016, 03:10:46 AM

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

Title: Re: Export agrnts
Post by: Kubig on March 09, 2016, 07:52:35 AM

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.

Title: Re: Export agrnts
Post by: msh on March 09, 2016, 09:01:10 AM

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

Title: Re: Export agrnts
Post by: Leonxxx86 on March 09, 2016, 11:07:18 PM

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

Title: Re: Export agrnts
Post by: Leonxxx86 on March 10, 2016, 12:08:14 AM

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.