Past CDR files are absent in SFTP uploading

[Tobivan_Helden_2]

Hi,

Have CUCM 6.x with service parameter 'CDR Enable Flag' set to TRUE.

I changed the value for this parameter 1 month ago thus CDR flat files had to be collected.

Today I added external SFTP billing server via 'Serviceability | CDR Management' interface.

There was no servers specifed before today.

To my surprise the first date for CDR I got was today's date ! It's not what I expect !!

I need all CDR flat files beginning from date of 1 month ago due to today and further.

I have the default value for 'CDR / CMR Files Preservation Duration (Days)' parameter to 30.

Please, advice, why CUCM didn't upload earlier CDR files and where can I get them.

Thank you.

[Jaime Valencia]

That is WAD, just the same as when you enable CDR. It starts working from the moment you configure/activate it.

You would need to get the old files via CLI manually.

HTH

java

if this helps, please rate

[Tobivan_Helden_2]

1. But mentioned CDR parameter exist what for in that case ?

"CDR / CMR Files Preservation Duration (Days)"

Choose the number of days that you want to retain CDR and CMR files.

The CDR Repository Manager deletes files that fall outside the preservation window.

2. Please, advice, how to get them from CUCM via SSH CLI ?

Thank you.

[Jaime Valencia · Accepted solution]

To keep the files in the server, just that. It was never meant to keep the files and then send them with the billing server config.

Start by looking the files, should be:

file list activelog cm/cdr_repository/processed

Then file get and path of file.

file get

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1036459

HTH

java

if this helps, please rate

[Tobivan_Helden_2]

Jaime,

Great answer !

Is there any way to get those processed CDRs to local pc in b_a_t_c_h mode ?

For example, if I need to analyze some specific date it will be much quicker

to download them to local workstation at first, and then parse with some means.

{

admin:file list activelog cm/cdr_repository/processed/YYYYMMDD

cdr___YYYYMMDD0501_18155

cdr___YYYYMMDD0522_18156

cdr___YYYYMMDD0526_18157

cdr___YYYYMMDD0527_18158

cdr___YYYYMMDD0528_18159

cdr___YYYYMMDD0530_18160

cdr___YYYYMMDD0538_18161

cdr___YYYYMMDD0540_18162

cdr___YYYYMMDD0542_18163

cdr___YYYYMMDD0543_18164

...

cdr___YYYYMMDD1445_18545

cdr___YYYYMMDD1446_18546

cdr___YYYYMMDD1447_18547

cdr___YYYYMMDD1450_18548

cdr___YYYYMMDD1523_18549

cdr___YYYYMMDD1526_18550

cdr___YYYYMMDD1534_18551

dir count = 0, file count = 397

}

Thank you.

[Jaime Valencia]

I'm not a programmer so i just have an idea of could this could work =)

You would need to write down a small program to ssh into the server and then use the output of the list command to start doing a file get for all files and download them into your PC. Again, just an idea, i'm not sure if you can do this with a program you create.

HTH

java

if this helps, please rate

[ivan.garrido]

Hi java,

I need to download a capture-file from a CUPS with file get command, but appear the message "Invalid download directory specified."

I use:

admin:file get activelog platform/cli/cups.cap

Please wait while the system is gathering files info ...done.

Sub-directories were not traversed.

Number of files affected: 1

Total size in Bytes: 1584

Total size in Kbytes: 1.546875

Would you like to proceed [y/n]? y

SFTP server IP: 172.26.14.52

SFTP server port [22]:

User ID: cisco

Password: *****

Download directory: CUP

Invalid download directory specified.

I tried to change the Download directory valued, but does'nt works.

I using Core mini-SFTP server.

Any idea?

Regards,

Ivan Garrido.

[jasyoung]

I had the same problem with the same Core mini-SFTP server. There's something about it that the CM file transfer process doesn't like. It actually connects and creates all the directory structure in your SFTP directory, it just dies when trying to send the actual files.

Switch to FreeFTPD and it'll work.

[ivan.garrido]

Thanks jasyoung!!

I tested with FreeFTPD and it works fine!!

Thanks a lot.

Ivan Garrido.