Does anyone know of an SQL query that will help us see all currently logged-in agents for a specific team? We are migrating to UCCE from three UCCX clusters and are currently gathering site data. We have several different teams, and we would like to run SQL queries to gather this information. The queries we are interested in are listed below.
- SQL Query for Displaying the Current count of logged-in agents for a specific team.
- SQL query to return the current agent IDs of all logged-in agents for a specific team.
- SQL Query for Outputting the Total count of configured agents for a specific team.
Any help with the following SQL queries would be very helpful to us. I've been experimenting with some queries but can't get the results I want.
Thanks!