A common scenario we get asked is “how do I find failed calls?” Sometimes this is outside of any sort of reporting context – it’s that you just want to browse through calls that failed, perhaps filtering on a particular phone number.
It turns out the answer is really quite easy!
Well, first I’d suggest reading about the field we’ll use a lot of on our Home tab. In the bottom pane, search for “call_failed” if it’s not visible, and when you find it read up on what it says.
Be sure to click the little “(expand)” link to show the rest of the description.
Then, let’s head over to Browse Calls.
(As with all images on our site, click on the image above to open a larger version!)
These steps creates a search filter of call_failed=”1″ and applies it to your calls so you’ll be left with a list of failed calls.
That was easy!
If you only care about a calls for a certain set of numbers, filtering this list farther is simple.
Into the enter number(s) field in the upper left, add in the number or numbers you want. This will search in callingPartyNumber, originalCalledPartyNumber, and finalCalledPartyNumber.
You can comma-separate multiple numbers, and wildcards are supported, so this here: 112233, 4545*,*5555 will find where the number is 112233, where it starts with 4545, or where it ends in 5555. That last option is handy if you don’t know for sure how the number looks in the CDR data. For instance, if my number was 7158917420 but I don’t know if UCM will report that as 17158917420 or 917158917420, I could just use *7158917420 to catch them all.
Here I’ve added *4361,9787359068 and you can see the results.
Sometimes you really don’t care about certain results.
For instance, in one of my screenshots you’ll see the first search result has a cause_description of No answer from user (user alerted). Let’s pretend we don’t care about those and would like to remove them from the search.
Find the field value you’d like to exclude, click on that value, and select the option to exclude it. In this case, exclude cause_description=”No answer from user (user alerted)”
The search filters gets updated and like magic, away go the “No answer from user (user alerts)” results.
You can repeat this for other cause_descriptions that you’d like to remove, too!
If you stumbled across this article and haven’t installed our trial yet, you should do so.
Download your 90 day trial license now.
Building a “report” of any of this is also real easy, so if you wanted a pretty chart out of failure codes you can take any of the above list of calls and jump straight to step 4 in our Quick Wins blog to put it on a chart!
Lastly, we use “call_failed” a lot in our Cisco CDR Reporting and Analytics Quick Tour video, so you can see all sorts of other things you can do with it.