Blogs

From time to time we hear of customers who want to print scheduled reports. They want their report to be sitting in the printer waiting for them in the morning, that sort of thing. CUIC doesn't support this as built-in functionality, but you can do it using Microsoft Outlook.
...Read More

 

There is quite a bit of interest in different techniques for using multiple AW/HDS servers with a single CUIC instance, for a number of reasons.

One reason people typically want to use multiple AW/HDS servers is to spread the load from a CUIC instance to multiple data sources. I've already blogged in the past about ...Read More

 

With the release of CUIC 7.5.3, there is one grid, the grid that was previously known as the "grouped grid". Since it now supports dynamic sorting it is now the only grid available.

One of the nice things about this grid is that much of its appearance can be customized by modifying the CSS (cascading style sheet) file that dictates its appearance. This is an undocumented technique, but should be fairly straightforward for anyone with a bit of HTML experience.
...Read More

 

I've just published a fairly comprehensive list of ways to improve performance of CUIC 7.5.x on the Developer Community at http://bit.ly/85kB.

There are a few items that I've covered in blog posts before, but a ton of new content as well. The document covers the following topics:

  • Server considerations
  • Configuration options
  • Database maintenance
    • ...Read More

 

Want to show off your Web 2.0 mojo? Here's a fun way to share reports with your Twitter contacts.

First, find the report you want in the Report Manager, right-click it, and click on the Report Info context menu item.



The Report Info dialog is very handy, it gives you all the information you need to access a report without using the CUIC menus. Here, we want the "Interactive Grid Permalink":


...Read More

 

When you write a custom report, it's always a good idea to use the SQL NOLOCK hint to improve performance and reduce the chance of deadlocks.
...Read More

 

In some very specific instances, you may want CUIC Web servers to share a database but query different AW/HDS servers, to split load. At first glance this doesn't seem possible as the AW/HDS that is queried is defined by a data source, which is stored in the CUIC database. However, there is a workaround which I'll show you in this post.
...Read More

 

Most people don't realize just how extensible CUIS is. You can do a lot with it, however, if you know what you're doing.

For example, most people don't realize that you can build a completely custom display using custom-built XSLT files. It's true! You can give CUIS your own stylesheets, and then tell the report to use that stylesheet instead of the default displays.
...Read More

 

Showing 8 results.
Items per Page 20
of 1
First Previous Next Last

Forums

« Back to Contact Center Reporting

Unable to use SELECT TOP (10) on CUIC Report Definition?

Combination View Flat View Tree View
Threads [ Previous | Next ]
Unable to use SELECT TOP (10) on CUIC Report Definition?
select top sql queryquery
Answer
10/21/12 6:02 PM
I would like to be able to create a report which outputs just the first 10 results from an SQL query.
 
My SQL query is fine when I run it on the server, but if I create the Report Definiation, it will not allow you use TOP (10) in the Query.
Anyone have any ideas to be able to work around this issue?
Is there another way to achieve the same result or does anyone know why I am unable to use TOP (10) in the SELECT Query?
Regards,
Gerry
 
 
 
 
Flag

Automatic reply: New Message from Gerard O'Rourke in Contact Center Reporti
Answer
10/21/12 6:03 PM as a reply to Gerard O'Rourke.
I'm currently overseas till Nov 5th with limited access to email. I will try to respond to your request in a timely fashion.
Flag

AUTO: Gregory Grebin is unavailable (returning 10/26/2012)
Answer
10/21/12 6:04 PM as a reply to Gerard O'Rourke.
I am out of the office until 10/26/2012.

I am on PTO with limited access to email and phone.



Note: This is an automated response to your message "New Message from
Gerard O'Rourke in Contact Center Reporting (CCR) - Contact Center
Reporting: Unable to use SELECT TOP (10) on CUIC Report Definition?" sent
on 10/21/2012 01:02:05 PM.

This is the only notification you will receive while this person is away.


Prime Therapeutics made the following annotations
---------------------------------------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.


---------------------------------------------------------------------
Flag

RE: Unable to use SELECT TOP (10) on CUIC Report Definition?
Answer
3/15/13 10:34 AM as a reply to Gerard O'Rourke.
Got this working ages ago.
Should have update this dicussion.
below is a Report which grabs the last 20 calls.
You can filter on ANI so you only see the calls you made etc.
Very useful for troubleshooting and finding out what the Dialed number is, if the dialplan is not well designed.
http://orourke.tv/web/doku.php?id=cisco:uc:icm:sql
http://orourke.tv/web/lib/exe/fetch.php?media=cisco:uc:icm:last20calls-callroutedetail_v1-02.zip
Below is an extract of the SQL
SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
SELECT TOP (20)
StartDateTime = Route_Call_Detail.DateTime,
DBDateTime = Route_Call_Detail.DbDateTime,
ANI = ISNULL(Route_Call_Detail.ANI,'NULL'),
DialedNumberString = Route_Call_Detail.DialedNumberString,
RoutingClientID = Route_Call_Detail.RoutingClientID,
RoutingClientName = Routing_Client.EnterpriseName,
..
..
..
..
FROM
Route_Call_Detail(nolock),
Script(nolock),
Master_Script(nolock),
Call_Type(nolock),
Routing_Client(nolock)
WHERE
(Route_Call_Detail.ScriptID = Script.ScriptID) AND
(Script.MasterScriptID = Master_Script.MasterScriptID) AND
(Route_Call_Detail.CallTypeID = Call_Type.CallTypeID) AND
(Route_Call_Detail.RoutingClientID = Routing_Client.RoutingClientID)AND
(Route_Call_Detail.DbDateTime > GetDate()-1)
ORDER BY
Route_Call_Detail.DbDateTime DESC
 
Flag

Collateral


No files available