Does anyone know what the query would be to duplicate the real time resource stats page in version 8 or above of UCCX? I need to build a custom web page that displays the same information. I've got all the connectivity to the database just fine and can query it and display information. Just can't figure out what the SQL would be that would extract that information.
SELECT x.resourceName, t.eventType, x.datetime FROM (SELECT t1.resourceID, t1.resourceName, MAX(t2.eventDateTime) AS datetime FROM Resource AS t1 INNER JOIN AgentStateDetail AS t2 ON t2.agentID = t1.resourceID GROUP BY t1.resourceID, t1.resourceName ) AS x INNER JOIN AgentStateDetail AS t ON t.agentID = x.resourceID AND t.eventDateTime = x.datetime ORDER BY x.resourceName
You will need to translate the eventType into the "readable" status like Talking or Not Ready with an IF or Case statement.
Unfortunately this query only produces the current agent state. What I was hoping for was to display the actual agent statistics for the day, like the real time reports do. The number of calls handled, average talk time, average hold time, that stuff. The real time reports tool gets that information. I suspect it might be one of the stored procedures, but I don't know.
IntroductionCUCM Routing RulesDial String implementation PolicyCUCM Routing LogicSIP URI Call Routing Analysis+++ Case Study: 1 ++++++ Case Study: 2 +++Conclusion
Over the last few months, I have had the privilege of working on SI...
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...