Does anyone know of a SQL Query that will help us see all current logged in agents for a specific teams? We are converting to UCCE from 3x UCCX clusters and were site gathering now. We have a bunch of different teams and we would like to perform SQL queries to gather this information. Queries we are interested are below.
- SQL Query for outputting the current count of logged in agents for a specific team.
- SQL Query for outputting the current agent ID’s 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 for us. I’ve been playing around with some queries but can’t get the output I wanted.