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

call detail report stored in TMS

Hi all,

I'm looking for a way to export CDR stored in TMS: I think TMS doesn't export CDRs in XML form, right?

Anyway I know that TMS DataBase records traffic data generated by TPS: looking at TMS DataBase I found table <objSystemConferenceParticipantCDR> filled with CDR useful informations and datas, but now I would like to know:

1) procedure and modality used by TMS for populating the table <objSystemConferenceParticipantCDR> (ie real time, one time in a day, every 60 minutes, every 30 minutes...)

2) As TPS stores in its memory up to 2000 records (ref. < cisco_TelePresence Server API-CDR>), and the following data overwrites records, are datas on TMS DB table <objSystemConferenceParticipantCDR> overwritten too or appended?

Thanks in advance

Everyone's tags (5)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

call detail report stored in TMS

I think TMS doesn't export CDRs in XML form, right?

Correct.

Anyway I know that TMS DataBase records traffic data generated by TPS: looking at TMS DataBase I found table filled with CDR useful informations and datas, but now I would like to know:

Please do not build business criticial applications on top of the TMS database as the database schema may change in future releases without prior notice. Consider yourself warned!

1) procedure and modality used by TMS for populating the table (ie real time, one time in a day, every 60 minutes, every 30 minutes...)

For the TelePresence Server: TMS builds a CDR within a few seconds from when the TS informs TMS that the conference has disconnected.

For the TelePresence MCU: New CDRs are collected from the MCUs every 60 seconds.

2) As TPS stores in its memory up to 2000 records (ref. < cisco_TelePresence Server API-CDR>), and the following data overwrites records, are datas on TMS DB table overwritten too or appended?

No data is ever overwritten, unless the admin explicitly chooses to purge historic call data.

Regards,

Kjetil

12 REPLIES
Cisco Employee

call detail report stored in TMS

I think TMS doesn't export CDRs in XML form, right?

Correct.

Anyway I know that TMS DataBase records traffic data generated by TPS: looking at TMS DataBase I found table filled with CDR useful informations and datas, but now I would like to know:

Please do not build business criticial applications on top of the TMS database as the database schema may change in future releases without prior notice. Consider yourself warned!

1) procedure and modality used by TMS for populating the table (ie real time, one time in a day, every 60 minutes, every 30 minutes...)

For the TelePresence Server: TMS builds a CDR within a few seconds from when the TS informs TMS that the conference has disconnected.

For the TelePresence MCU: New CDRs are collected from the MCUs every 60 seconds.

2) As TPS stores in its memory up to 2000 records (ref. < cisco_TelePresence Server API-CDR>), and the following data overwrites records, are datas on TMS DB table overwritten too or appended?

No data is ever overwritten, unless the admin explicitly chooses to purge historic call data.

Regards,

Kjetil

call detail report stored in TMS

Hi Kjetil!

how about finaly getting some simple but proper cdr generation / export in TMS or VCS

Please remember to rate helpful responses and identify

Cisco Employee

call detail report stored in TMS

Hi Martin,

I would personally love to see improved reporting in TMS and on the VCS. But unfortunately, I am not in charge of the product roadmap. I think you need to go through the regular channels (i.e. your account team) for such requests.

Regards,

Kjetil

call detail report stored in TMS

ah, I think we requested that 2-3 years ago, ...

Please remember to rate helpful responses and identify

New Member

call detail report stored in TMS

Hello,

Also I think Tms can be report Cts endpoint Cdr which is connected to CUCM.

Regards,

Baris.

Cisco Employee

call detail report stored in TMS

Hi Baris,

No, there is no support for endpoint CDRs from CTS systems or gatekeeper CDRs from CUCM systems managed by TMS.

Regards,

Kjetil

New Member

call detail report stored in TMS

Thank you Kjetil for your answers. So, where and how can I get CDRs in a "safe" way? Any suggestion?

Cisco Employee

call detail report stored in TMS

The only safe way of exporting CDRs from TMS is the "Export Excel" button in the web interface. No other method is supported by Cisco.

Regards,

Kjetil

New Member

call detail report stored in TMS

Hi Kjetil,

Thats ok. But, for example our customer have 35 CTS, 100 tandberg and 120 polycom endpoint.

They not calculating truly cdrs because of cdr diveded by CUCM and TMS.

Regards,

Baris.

Cisco Employee

Re: call detail report stored in TMS

Hey Baris,

I have a feature request in for TMS to support CDRs for CTS endpoints. For your reference it is CSCtx03940.

Adam

Sent from Cisco Technical Support iPad App

New Member

Hi Sipser, Did you ever make

Hi Sipser,

 

Did you ever make any progress on this request to export CDR information from TMS managed video endpoints?  This should be a standard feature as it is in the CUCM platform.

Thanks,

 

Amir

VIP Green

You can export the TMS Call

You can export the TMS Call Detail Records to Excel:

Reporting > Call Detail Record

Once you've selected and run the required report, if you click on the "Data" tab, there is an "Export Excel" button at the bottom.

Wayne
--
Please remember to rate responses and to mark your question as answered if appropriate.

Wayne
--
Please remember to rate responses and to mark your question as answered if appropriate.
1245
Views
10
Helpful
12
Replies
CreatePlease login to create content