Export Agents as CSV

8 Comentarios

  • Ewa Kondratowicz

    Hi Roman Sheydvasser,

    I recommend using Zendesk Analytics (Insights) report for that.  You can create a simple report showing all the users (and filter out all end-users) along with their role (Agent, Administrator).  It's not showing the most up to date status - the data is downloaded only once a day, but that's enough for me.  

  • John Witt

    It took me a minute to figure out, but you need to have your metric as number of users, then you can have users as attribute and filter on user role. Number of users will be 1 for each entry. I was wasting time with tickets and submitter/assignee/requestor.

  • Andrew Lee

    Hi Ewa Kondratowicz,

    Can you please confirm the steps for this

  • Ewa Kondratowicz

    Andrew Lee

    Choose # Users in What, User Name and User Role in How and User Role isn't End-user in Filters.  Et voila! :)

    Hope it helps!

  • Amy Ng

    Ewa Kondratowicz Can you confirm those steps in Zendesk Explore instead of GoodData? 

  • Kelsa Henry

    Yes, Agreeing here. 

    Hello Ewa, can you share the steps for Explore please? I'd be super grateful. 


  • Sergei
    Zendesk team member

    There is nothing like it in Explore, I am sorry to say. Explore returns data based on datasets and those datasets are connected to objects/events, so unless object exists or an event has occurred - no data will be returned. 
    Explore can filter for user types, but only in regards to ticket requesters. If an agent has never been a requester of a ticket - you will not be able to get required data.

    I would advise to use Search API to get the list of agents in JSON format (see here: https://developer.zendesk.com/rest_api/docs/support/search) and then you could utilise any tool available, that would convert JSON to CSV or Excel. There are plenty of free options available online.

    Basic search query would look like this: subdomain.zendesk.com/api/v2/search.json?query=type:user%20role:agent

    You can simply copy/paste it to your browser's address bar, adding your subdomain.

  • Kelsa Henry

    Just as a work around, I found using the Customer List in ZD was super easy to view and export all my agents according to Organizations. The only limitation is you are not able to tell if Chat is enabled on their profile. However, you can easily export, view last login in an excel file.

    Hope this helps. 



Iniciar sesión para dejar un comentario.

Tecnología de Zendesk