Using Microsoft Access and ODBC connectivity to the queries on the AWDB, I have been able to successfully re-create the Agent Consolidated Daily Report.
Now I am trying to re-create the Agent Team Consolidated Daily Report and my time calculations are just not giving me the same numbers as the Cisco WebView report.
I've attached screen prints.
Any help would be greatly appreciated!!!!
BTW, I am doing this because not everyone in my organization has access or knowledge of SQL, and there are other reports our end users want that are not currently available from WebView. I am re-creating these as learning tools to familiarize myself with the data and the different calculations.
Looking at the figures in your attachment it seems to be a rounding error as there's only a difference of a second between your IncomingHandledAHT figure and the WebView Incoming AHT figure, It looks like your query is rounding up the result to full seconds, whereas the WebView report is rounding down.
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...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.