Query CDR database, need help finding table.

[Sergio Fare]

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.

[Gordon Ross]

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