Genesys Cloud - Main

after 2 years 4 months, today I face the same issue , my customer is asking to findout how to pull a report to list

Agent / skill / skill level 

and I start googling and found this thread . but not sure after all this years, did genesys come out with a good solution ?

We paid for a SQL DB integration, apart from other things to integrate with our Tableau reporting suite.  I had included part of the API the agent/skills/proficiency to be added to a table exactly for this.  We have loads of skills so it was definitely needed.  If i want to check on who has a skill within Genesys I use a Dummy Queue and then add members based on skill, the other way you could do it is with skill expression groups.  This would certainly list all users 

after 2 years 4 months, today I face the same issue , my customer is asking to findout how to pull a report to list

Agent / skill / skill level 

and I start googling and found this thread . but not sure after all this years, did genesys come out with a good solution ?

ya ... it manage to show agent + skill, but I need to findout the skill proficiency , and I cant anywhere to get proficiency  report

We paid for a SQL DB integration, apart from other things to integrate with our Tableau reporting suite.  I had included part of the API the agent/skills/proficiency to be added to a table exactly for this.  We have loads of skills so it was definitely needed.  If i want to check on who has a skill within Genesys I use a Dummy Queue and then add members based on skill, the other way you could do it is with skill expression groups.  This would certainly list all users 

after 2 years 4 months, today I face the same issue , my customer is asking to findout how to pull a report to list

Agent / skill / skill level 

and I start googling and found this thread . but not sure after all this years, did genesys come out with a good solution ?

I will see if I can find it, but some time ago, I created an Excel Workbook which accessed the API to download a list of users and Skills and then create a cross-reference table with the proficiencies in it (for those with skills assigned.) It also gave a summary of how many agents had the skill at each proficiency level.

I will see if I can dig it out and post details.

Word of warning, though - it's slow! (about 600 Users / 100 Skills took anything up to 30 minutes to process) so not useful for real time reporting.

------------------------------
Paul Simpson
Views expressed are my own and do not necessarily reflect those of my employer.
------------------------------

@Alex Goh Have you tried using the Genesy CLI?

I use this little command

(gc users list -a --expand="id,skills" | ConvertFrom-Json) | Select-Object id, name, title, state, department, @{Name="Skills"; Expression={$_.skills.name}}, @{Name="Prof"; Expression={$_.skills.proficiency}} 

Which gives a list of users, their skills and their proficiency level for those skills. Which you can then filter, separate values to columns etc

Edit: To export to CSV, just add this to the end | Export-Csv -Path .\FileName.csv -NoTypeInformation

------------------------------
Anton Vroon
------------------------------


Original Message:
Sent: 01-16-2024 11:09
From: Paul Simpson
Subject: Skills - Which agents have a specific skill assigned?

I will see if I can find it, but some time ago, I created an Excel Workbook which accessed the API to download a list of users and Skills and then create a cross-reference table with the proficiencies in it (for those with skills assigned.) It also gave a summary of how many agents had the skill at each proficiency level.

I will see if I can dig it out and post details.

Word of warning, though - it's slow! (about 600 Users / 100 Skills took anything up to 30 minutes to process) so not useful for real time reporting.

------------------------------
Paul Simpson
Views expressed are my own and do not necessarily reflect those of my employer.

I will see if I can find it, but some time ago, I created an Excel Workbook which accessed the API to download a list of users and Skills and then create a cross-reference table with the proficiencies in it (for those with skills assigned.) It also gave a summary of how many agents had the skill at each proficiency level.

I will see if I can dig it out and post details.

Word of warning, though - it's slow! (about 600 Users / 100 Skills took anything up to 30 minutes to process) so not useful for real time reporting.

yes ... if there is way to pull it in excel workbook will be good . as I need an easy non technical way for supervisor to pull the report daily

I will see if I can find it, but some time ago, I created an Excel Workbook which accessed the API to download a list of users and Skills and then create a cross-reference table with the proficiencies in it (for those with skills assigned.) It also gave a summary of how many agents had the skill at each proficiency level.

I will see if I can dig it out and post details.

Word of warning, though - it's slow! (about 600 Users / 100 Skills took anything up to 30 minutes to process) so not useful for real time reporting.