Custom Wallboard - SQL Help for lost AgentStateDetail records
I've got a custom-written wallboard to monitor agents and traffic real-time. When I change the Agent competence level or remove a skill, the agent's records are no longer available in the AgentStateDetail table. Because of this, the agent's status is unknown until there is a new status change generated by the CAD agent (a new entry in AgentStateDetail is then created). Is there a way around this?
Cisco Unified CCX Premium - 7.0(1)SR03_Build011 HA
Re: Custom Wallboard - SQL Help for lost AgentStateDetail record
The Agent resourceID changes in the Resource table whenever you modify the agent skills. I had an inner join with the AgentStateDetail.agentID to Resource.resourceID that would fail due the the new resourceID for the agent.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...