05-08-2010 12:04 PM - edited 03-14-2019 05:42 AM
Hi,
When I run a query with CCX Historical Report, for example on the activity by CSQ, I see all the CSQ and the CSQ removed.
Anyhow, any help would be appriciated.
Thanks
Romuald
05-12-2010 06:21 AM
Romuald
In order to delete the agents in a permanet way you need to go to the "RmCm" subsystem, after that go to "Resources" and select the Inactive Agents the option, then select the agents that are not longer part of that CSQ and delete them from the system. Regarding the of the CSQs I will need to check that here.
HTH
Please rate this post if was helpful
Walter Solano
CCNA Voice
Cisco UCCX Specialist
05-12-2010 03:46 PM
Historical data is generated based on what was configured in the period the report is ran.
So if an agent or csq existed in January, and you run a report for January, you will see that agent or csq.
However, if you run that same report, but for February, you should not see that agent or csq. Is this what's happening to you?
05-14-2010 01:39 AM
Hy Anthony,
I thought the same solution. I deleted a CSQ for six months. When I run a query on a CSQ for the last month, the deleted CSQ appears always.
I purged the database, with the tools "Purge Now". The result is the same.
I believe that if an entry is created in the database, it can not be removed with a tool, perhaps with an SQL query ?
This problem is not critical, I can work around with the scheduler. My client will not see this problem.
Thank you for your help.
Romuald
09-03-2010 07:05 AM
I got similar problem. There are 6 CSQs in CCX (2 old based on Resource Group selection, 4 new based on Resource Skill selection).
In Java real-time monitor, I see correct CSQs displayed, same as in CCX Administration.
But in Historical Report app. there are some more "testing" CSQs which have already been deleted from CCX about 3 months ago.
Customer would like make them removed, is there any hint how to solve this? Or any workaround?
Thanks in advance..
-- Jiri
09-03-2010 08:11 AM
Hi Romuald,
The only way to remove the CSQ's as you suggest is to remove the "appearance" in the filter list of the historical report generator. Then you will have to use the Filters when creating the report. The CSQ's are perminent in the database and removing them manually is not supported nor is it advised. But by changing the query in the reporting template you can remove the CSQ appearances in the historical reporting client. Note, this is done on the HRC Client machine, not on the Server...
I have done this before for application names. So for instance, the ICD_Application_Summary_en_us.xml file which is located under c:\program files\Cisco CCX Historical Reporting\Report Templates\en_US has a SELECT query that appears like the following:
If I wanted to change the appearance of what is displayed in the filter list I would change this in the following way:
So for your issue, to remove CSQ appearances you will likely have to do the same thing but in something like the ICD_Detailed_Call_CSQ_Agent_en_us.xml or if the reports you are running are using a different template you will need to edit those. In that file you will find the SQL select statement:
So you would need to change that to something like the following:
In this way you will exclude the CSQ's from showing up in the filter list. Someone can run the reports and select all the CSQ's in the filter list and this should exclude the ones you do not want on the report.
Please let me know if you have any questions about this and if this has been helpful please rate the post.
Thanks
Mike
02-22-2011 06:06 PM
Ok we have a similar issue:
We set Teams with their respective Supervisors.
When those supervisors go on to generate a report on their CSQ, they See every single CSQ out there. That is unacceptable. HELP please.
11-16-2011 09:55 AM
Were you able to fix this issue. We are having the same issue where each supervisor can see all the CSQ reports and we only want those guys to see their individual teams reports. Please help.
11-17-2011 06:26 AM
Any agent who has 'Historical Reporting' capability can generate historical reports. Administrator grants 'Historical Reporting' capability to agents through appadmin. If an agent/supervisor has the capability, then he/she can view the reports for all the agents.We can't restrict based on teams. This is as per the design.
Please rate helpful posts.
GP.
11-18-2011 09:01 AM
One of the advantages of our Reporting Tool is that each login can be designed to have access to specific groups and their associate agents. They can not view or generate reports on other groups. Please let me know if we can help with our 3rd party solution.
Ron Reif
11-18-2011 12:35 PM
I wasn't quite sure where to post this, forgive me if it's in the incorrect channel. I am attempting to run Cisco Unified CCX Historical Reports. When I choose print a report and choose the option to "Include Charts On Report", it prints with all the names to the left of the chart, and the names are overlapping one another from top to bottom. There is not a setting to reduce the font. Any assistance would be appreciated. Thanks.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: