I'm afraid you're probably not going to find an efficient way to do this. The Agent_Skill_Group_Real_Time table only holds the most recent Agent state - that's where existing Agent RealTime reports get that data.
If you enable Agent State Trace on individual Agents, you can get extended data about Agent states from the Agent_State_Trace table. However, this gets large very quickly, and running custom reports on it while it's in the HDS is very resource-intensive... especially for the needs of a Real-Time report. To get good Real-Time data out of this table, you'd have to do very regular exports (every few seconds) of the data to an external database, and index the exported table differently for your needs.
Audio and Video Endpoints Knowledge Base
For one-on-one help with these products, you can open a ticket at https://developer.cisco.com/site/support/. For other products, please contact Cisco TAC at https://www.cisco.com/c/en/us/support/index.ht...
I want to find out how many agents are configured for an attribute. I have followed all the steps which are provided by the Cisco UCCE 11.6 API guide but I could not get the count. Is it possible to get a count of agents or not?
Collaboration Management Knowledge Base
For one-on-one help with these products, you can open a ticket at https://developer.cisco.com/site/support/. For other products, please contact Cisco TAC at https://www.cisco.com/c/en/us/support/index.html
Lately I have received a few requests from people asking if it was possible to Archive a Webex MessageSpace as in "download all messages".Interesting.
You can download all messages using the messages API but that leaves yo...