CUCM Block Inbound Callers by Caller ID on CUBE or gateway level

For information on blocking inbound callers by caller ID on MGCP gateways via CUCM, see my old post here: http://webmaxtor.blogspot.com/2017/12/blocking-calls-based-on-calling-party-id.html

Since a co-worker and an old client just recently asked about doing it at the gateway level using SIP trunks, here's a quick synopsis of one way to do it:

Create a voice translation rule that identifies calls with a very specific number.  Here for example I am focusing on the telephone number +1(716)555-1212.

!
voice translation-rule 99
    rule 1 reject /7165551212/
!

Then create a translation profile that indicates you want to use that rule when looking at calling numbers.  Since we are looking to block a caller with this caller ID the profile would look like so, keeping in mind the word BLOCK is just a label and could be anything.

!

voice translation-profile BLOCK

 translate calling 99

!

Then use that profile to block calls handled by a specific inbound dial peer.  Here dial peer 88 is the incoming dial peer that handles calls from the PSTN.  The profile we created called BLOCK is used to identify which incoming calls on this dial peer should be rejected.

!

dial-peer voice 88 voip

    call-block translation-profile incoming BLOCK

    call-block disconnect-cause incoming call-reject

!

Webex Contact Center CJA report on IVR menu option dialed

I was recently asked to set up a simple telephony IVR with six options and provide the ability to report on which options were chosen by callers.  

In UCCX world I would use a Set Enterprise Info step to write a custom variable and then report on it later.  Here, since some of the IVR options were already being served by Webex Contact Center I wanted the IVR and reporting to be a function of Webex as well.

Below is what I came up with after a tip from the Reddit r/ciscoUC group found here: https://www.reddit.com/r/ciscoUC/comments/wrqw7v/webex_contact_center_menu_option_selection_report/ 

1. new Global Variable created called Global_OptionEntered
2. new dialed number to Entry Point Mapping
3. new Entry Point to new Flow Routing Strategy
4. Flow IVR created with Menu activity with six Custom Menu Links
5. Each Menu Link flow path is connected to a Set Variable activity
6. Each Set Variable activity set the Global_OptionEntered variable to a string that describes the reason for the option selected. For example, option 1 was set to "1. Vanilla", option 2 was set to "2. Chocolate", etc.
7. The Set Variable flow path was then connected to a Blind Transfer activity to send the caller to another system, or to a GoTo activity to route the caller to another Entry Point already in production in Webex Contact Center.

Set Variable

1. In CJA create a new visualization with the Customer Session Record type
2. The Row Segment is the new global variable Global_OptionEntered
3. The Profile Variable is the Count of Global_OptionEntered
4. The Filters is Global_OptionEntered "is in" and the six strings (i.e. "1. Vanilla", "2. Chocolate", etc.) written to the variable by the Set Variable activities in the flow.

CJA Customer Session Record Filter

1. The report output is then basically this:

Sample Report Output

CUCM SQL

This provides devices and DNs where the External Phone Number Mask is like 7162010662. The percent sign allows you to allow for an unknown number of characters if you are searching for partial numbers. This sample sorts by device name.

run sql select d.name, d.description, n.dnorpattern, dmap.e164mask from device as d inner join devicenumplanmap as dmap on dmap.fkdevice = d.pkid inner join numplan as n on dmap.fknumplan = n.pkid where dmap.e164mask like '%7162010662' order by d.name

This provides Translation Patterns where the Called Party Transform Mask is starts with 330.

run sql select dnorpattern, calledpartytransformationmask from numplan where tkpatternusage=3 and calledpartytransformationmask like '330%'

This provides CUCM phone Device Name, Description, Model and Phone Load Name configured on device if present:

run sql SELECT d.name AS device, d.description, m.name AS model, d.specialloadinformation AS device_load FROM device d INNER JOIN typemodel m ON d.tkmodel = m.enum WHERE m.tkclass = 1 ORDER BY m.name, d.name;