Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Query CDR database, need help finding table.

Hi,

I was asked to generate the following report:

  1. How many times for a certain amount of time both lines a certain extension has both lines simultaneously used.
  2. How many times for a certain amount of time a certain extension rings busy due to both lines being in use and another call comes in.

Per Cisco documentation, I can probably find the field names. However, which tables would I need to query for the above requests? Cisco documentation shows a lot of tables, and it doesn't tell me which fields are in which table or visa versa.

Thank you so much.

1 REPLY

I'd advise against doing too

I'd advise against doing too much raw SQL query work on CUCM - It's a call processing platform, not a reporting platform. Take the CDRs and feed them into your own database (or purchase a CallLogger which can do it automatically) and run queries from there.

 

GTG

Please rate all helpful posts.
36
Views
0
Helpful
1
Replies
CreatePlease to create content