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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CCX 7.0.(1) Historical Reports - No data

Hi,

The historical reports were running ok. We now receive a 'no data to view' when running reports

for any date range. I have checked Purge and the data base is showing 74% of 2048mb and

purge data older that 13 months.

Purge schedule is set for older than 99 months

Auto purge is set to purge when the database exceeds 70% of 2048mb

Auto purge data for the oldest 15days

Has anyone seen this before? or know how I can check to see data is still available.

any ideas greatefully received.

Thanks

dominic

3 REPLIES

Re: CCX 7.0.(1) Historical Reports - No data

Hello Dominic,

One questions. Do you a single server deployment or you have HA?

New Member

Re: CCX 7.0.(1) Historical Reports - No data

Hi Walter, It is a single deployment.

Silver

Re: CCX 7.0.(1) Historical Reports - No data

Hi Dominic,

Try this. From the cmd run the following MSDE query:

osql -E -S HOSTNAME\CRSSQL -Q "USE db_cra SELECT * FROM ContactCallDetail WHERE (startDateTime >= 'MM/DD/YYYY') AND (startDateTime <= 'MM/DD/YYYY')"

This will tell us if there is data available for the selected range of date.

HTH

373
Views
5
Helpful
3
Replies