11-15-2013 04:03 PM - edited 03-16-2019 08:26 PM
Hi all,
We would like to have clear call reports for some users. Here is what we tried from CDR Analysis and Reporting.
1. CDR->Search by Phone Number: it did generate some level of reports in the table in webpage, but there is no call duration information and it will be a pain to export the report because it will be only in raw data;
2. If we export the CDR directly, we do have complete data, but we don't have a good way to read the raw data again.
Any suggestion to generate a readable call report easily? Thank you.
Solved! Go to Solution.
11-16-2013 02:40 AM
Hi Gary,
In order to pull CDR information, you can perform the following steps:
1. Go to 'Cisco Unified Serviceability' of the Publisher and click on Go.
2. Select Tools -> CDR Analysis and Reporting.
3. Go to CDR -> Export CDR/CMR.
4. Select the From and To date. (Make sure you have 'CDR Records' option selected)
5. Click on Export to file.
6. Right Click on 'CDR Dump' and save it using Save Target as/Save link as.
7. If you want to retain the CDR file in the call manager, please 'uncheck' the Delete File option.
Now the file would be saved on your system and you can open it in Microsoft
Excel using the following steps to have it in a readable format.
1. Open Excel -> File -> Open -> Select the file saved -> click on open.
2. Use 'Delimited' -> Next
3. Select 'Tab' and 'Comma' as the Delimiters -> Click on Next.
4. Select Current data format as General -> Finish.
Now, you should be able to view all the details in a Spreadsheet.
Note that the time of the records under 'dateTimeOrigination' coloumn would be in Epoch Time. It is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601:
1970-01-01T00:00:00Z).
In order to convert it in human readable format, you can look for Epoch convertor that is easily available on the internet.
You can also visit the following link to use a formula to convert the time into human readable format.
http://www.blindhog.net/convert-epoch-time-in-excel/
HTH,
Jagpreet Singh Barmi
11-15-2013 09:18 PM
Hi,
Select all the content in the webpage,paste in a notepad.
And save the filename has filname.csv and also in the filetype you select all files.
you will be getting the report in csv format
Regards,
Guru
11-16-2013 02:40 AM
Hi Gary,
In order to pull CDR information, you can perform the following steps:
1. Go to 'Cisco Unified Serviceability' of the Publisher and click on Go.
2. Select Tools -> CDR Analysis and Reporting.
3. Go to CDR -> Export CDR/CMR.
4. Select the From and To date. (Make sure you have 'CDR Records' option selected)
5. Click on Export to file.
6. Right Click on 'CDR Dump' and save it using Save Target as/Save link as.
7. If you want to retain the CDR file in the call manager, please 'uncheck' the Delete File option.
Now the file would be saved on your system and you can open it in Microsoft
Excel using the following steps to have it in a readable format.
1. Open Excel -> File -> Open -> Select the file saved -> click on open.
2. Use 'Delimited' -> Next
3. Select 'Tab' and 'Comma' as the Delimiters -> Click on Next.
4. Select Current data format as General -> Finish.
Now, you should be able to view all the details in a Spreadsheet.
Note that the time of the records under 'dateTimeOrigination' coloumn would be in Epoch Time. It is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601:
1970-01-01T00:00:00Z).
In order to convert it in human readable format, you can look for Epoch convertor that is easily available on the internet.
You can also visit the following link to use a formula to convert the time into human readable format.
http://www.blindhog.net/convert-epoch-time-in-excel/
HTH,
Jagpreet Singh Barmi
12-03-2013 04:38 AM
Hello,
why so complicated when there is available the sofisticated software for it?
Just take a look here: http://www.2ring.com/ca to obtain more information.
HTH,
Martin
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide