Cisco CDR Reporting & Analytics | Docs

Building Reports

Where do I start?

I need to create an advanced report, but I don’t even know where to start! Can you help me?

Yes, we can. Here’s a quick overview:

  • If the rows you need in the report are calls, select Investigate then Calls.
    If you haven’t yet, read the Usage page in these docs to learn how this page works.
  • If the rows you need in the report are people, select Investigate then Extensions.
  • Otherwise click Chart then Create new chart.
    • If you haven’t yet, familiarize yourself with the basic filtering and charting controls by reading our Usage and Search Tips pages.
    • From left to right, start changing options to build your report.
    • There is a huge range of potential fields and combinations of fields. If you are overwhelmed feel free to reach out to us for help
    • Refer to some of the searches below for ideas!

If you have any questions on what a certain field means, go back to the landing page of the app in Splunk and check out Explore Reports” and Explore Fields”. Many of the fields have links to pre-built reports that might point you in the right direction.

Some Examples

Report of all calls by site

If you or your colleagues have setup the app’s Sites lookup. then you can split your call volume chart by site simply by changing the split by drop down to select site.

Report on only inbound calls by site

Click the call types field and uncheck all except incoming. then click the drop-down for split by and select site

Report by hour of day

If you’d like to see the overall time spent per hour over the past week, configure your Chart page like the following:

  • Chart the sum
  • of duration_​in_​minutes,
  • over hour_​of_​day
  • with a split by of (none)
  • and a sort by of hour_​of_​day (ascending).

Report on minimum MLQK by hour

MLQK is an estimate of the MOS score of the last 8 seconds of the call, or a measure of the quality of a call. The closer this is to 4.5 the better the call quality is. If you wanted to see if there are certain hours of the day where MLQK is low, configure a report like the below:

  • Chart the min
  • of MLQK,
  • over hour_​of_​day
  • In this case, you will get results faster if you only count records with MLQK. In the other terms search box type MLQK>0
  • In the resulting Chart, change it to a line chart if it isn’t already.

Be sure to check out the other MLQK fields – MLQKav, MLQKmn, MLQKmx! Descriptions can be found by clicking Home in the main menu and searching for them in the Explore Fields section.

As you can see, the possibilities for how to display the data are endless. The app extracts the call quality data and consolidates it with the details from the CDR side so that you can filter and report and visualize this data in any way you like. Feel free to try other combinations!

Gateway Utilization

Are we dropping calls? Are we close to dropping calls? Or are we so far away from dropping calls that we should investigate *reducing* the number of lines we have?

  • From the main menu across the top, select Chart then select Call Concurrency and Gateway Utilization.
  • Change the selected gateways to a suitable subset, if necessary.
  • Change the time frame drop-down to a reasonable period.

Site to Site concurrency

You need to analyze the site-to-site concurrency for calls between locations that are not going out. You might be doing a lot of SIP trunking, or you might need to corroborate whether efforts to save money and reduce PRI usage are actually working. 

Note — for this to work, you or your colleagues must have already set up the app’s Sites lookup.

  • From the main menu across the top, select Browse then select Sites.
  • Click on a site.

If you have any comments at all about the documentation, please send it in to docs@​sideviewapps.​com.