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

ICM 7 webview call type report for only 50 previous days ?

Hi,

One of our customer using webview for call reports on ICM7 want to see as many days we can in Call Type Daily Report.

At this time we have 50days.

I can't find in ICM/webview documentation if this is a software limitation or if we can increase it.

Does someone knows if we can increase this value ?

Thank you.

Julien

2 ACCEPTED SOLUTIONS

Accepted Solutions
Green

Re: ICM 7 webview call type report for only 50 previous days ?

It's nothing to do with WebView, but everything to do with the HDS.

On your HDS, run ICMDBA and select the _hds database. Examine "Space Used Summary". Look at the Call_Type_Half_Hour table. How many days retention do you see?

Use SQL Enterprise Manager and check the properties of the database. Is it at 80% or more? If so, the HDS is purging data. If you have more space on your drives, add another data file to the database so it drops to 50% or so space used.

If you don't have any more space, add another pair of drives and add the data file.

If neither is possible, adjust the retention days on tables you don't wish to keep for as long as your call type tables to try to control what the HDS purges and what it keeps.

Regards,

Geoff

Green

Re: ICM 7 webview call type report for only 50 previous days ?

Juste an other question about the file, we have a lot of space available on this server with actual HDD.

To be sure and don't erase anything i create an other file on the same HDD and now we have more datas.

OK, that's good.

The customer need a lot of call history so we want to assign more space for logs but i'm not sure i can change the value of the data file just like that.

I just want to be sure that this modification won't erase previous datas ?

Do you mean the transaction log? Do you want to expand it? That's not a problem. Do it after close of business though.

Regards,

Geoff

7 REPLIES
Green

Re: ICM 7 webview call type report for only 50 previous days ?

It's nothing to do with WebView, but everything to do with the HDS.

On your HDS, run ICMDBA and select the _hds database. Examine "Space Used Summary". Look at the Call_Type_Half_Hour table. How many days retention do you see?

Use SQL Enterprise Manager and check the properties of the database. Is it at 80% or more? If so, the HDS is purging data. If you have more space on your drives, add another data file to the database so it drops to 50% or so space used.

If you don't have any more space, add another pair of drives and add the data file.

If neither is possible, adjust the retention days on tables you don't wish to keep for as long as your call type tables to try to control what the HDS purges and what it keeps.

Regards,

Geoff

New Member

Re: ICM 7 webview call type report for only 50 previous days ?

Hi Geoff,

Thank you for your help.

Juste an other question about the file, we have a lot of space available on this server with actual HDD.

To be sure and don't erase anything i create an other file on the same HDD and now we have more datas.

The customer need a lot of call history so we want to assign more space for logs but i'm not sure i can change the value of the data file just like that.

I just want to be sure that this modification won't erase previous datas ?

Thank you for your return.

Julien

Green

Re: ICM 7 webview call type report for only 50 previous days ?

Juste an other question about the file, we have a lot of space available on this server with actual HDD.

To be sure and don't erase anything i create an other file on the same HDD and now we have more datas.

OK, that's good.

The customer need a lot of call history so we want to assign more space for logs but i'm not sure i can change the value of the data file just like that.

I just want to be sure that this modification won't erase previous datas ?

Do you mean the transaction log? Do you want to expand it? That's not a problem. Do it after close of business though.

Regards,

Geoff

New Member

Re: ICM 7 webview call type report for only 50 previous days ?

Yes Geoff i meant the data file size.

I have a 160Gb HDD but only 10% used at this time.

I will see to increase the data file size.

Thank you for your help.

Julien

Green

Re: ICM 7 webview call type report for only 50 previous days ?

What was your original configuration of the HDS database (data file, trans log file)?

Regards,

Geoff

New Member

Re: ICM 7 webview call type report for only 50 previous days ?

At this time the data file is at 1400Mb only

We will increase the size of the file to appropriate size for the customer.

Bronze

Re: ICM 7 webview call type report for only 50 previous days ?

Yeh check the retention periods on each of the tables, sounds like they might be low. You can find them in the registry on the AW in:

HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems, Inc.\ICM\ucce\Distributor\RealTimeDistributor\CurrentVersion\Recovery\CurrentVersion\Purge\Retain

Cheers,

Nathan

374
Views
0
Helpful
7
Replies
CreatePlease login to create content