Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

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

2 REPLIES
Silver

Re: Custom Wallboard - SQL Help for lost AgentStateDetail record

As soon as the change to agent is made via CCM or LDAP, click on the Resources link in AppAdmin or try to restart the CRS engine.

Community Member

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.

Thanks for your help

287
Views
0
Helpful
2
Replies
CreatePlease to create content