Genesys Cloud - Main

 View Only
Discussion Thread View
  • 1.  List all users assigned to skill / Language

    Posted 03-23-2023 10:24

    Hello,
    Just wondering if anyone has written some code to produce a list of all agents assigned to a particular Skill/Language?
    If so would you be willing to share it?

    TYIA


    #PlatformAdministration
    #SystemAdministration

    ------------------------------
    Pete Schroeder
    HMC3 LLC
    Senior Contact Center Engineer
    pete.schroeder@hmcthree.com
    ------------------------------


  • 2.  RE: List all users assigned to skill / Language

    Posted 03-23-2023 11:28

    Here is one for skills

    gc -p {{profileName}} users list -a --expand="skills" | jq -r ".[] | [ .name, ([.skills[].name + \"(\" + (.skills[].proficiency | tostring) + \")\"] | join(\",\")) ] | @csv" > UsersWithSkills.csv



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 3.  RE: List all users assigned to skill / Language

    Posted 03-23-2023 19:22

    @Robert Wakefield-Carl 
    Thank You,  Much appreciated.

    I am not familiar with this syntax, is this to be used with CLI?

    Thanks again



    ------------------------------
    Pete Schroeder
    HMC3 LLC
    Senior Contact Center Engineer
    pete.schroeder@hmcthree.com
    ------------------------------



  • 4.  RE: List all users assigned to skill / Language

    Posted 03-25-2023 12:14

    Yes it is.  You can find more information about CLI here:  Introducing the Genesys Cloud CLI



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 5.  RE: List all users assigned to skill / Language

    Posted 03-26-2023 14:28

    @Robert Wakefield-Carl This is great!!

    I got CLI & JQ installed/configured, ran some examples from:   https://developer.genesys.cloud/devapps/cli/
    Once I learn the syntax, I will no longer need to run the API via API Explorer, then convert JSON to CSV, then  manipulate the data in excel

    While the output is fantastic,  can this query be revised to output like the attached sample: Skill-Users.xlsx
    Aloso each skill showed 3 times for each agent, see:  UsersWithSkills.csv,  Am I doing something wrong?

    Again, BIG  Thank You!!



    ------------------------------
    Pete Schroeder
    HMC3 LLC
    Senior Contact Center Engineer
    pete.schroeder@hmcthree.com
    ------------------------------

    Attachment(s)

    xlsx
    Skill-Users.xlsx   11 KB 1 version
    csv
    UsersWithSkills.csv   825 B 1 version


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources