Tag Archives: voip

CUCM Direct SQL Queries

When working with CUCM you quickly come to understand that the whole system is a big database front ended with an ok GUI and few communications protocol stacks.  The graphic interface gets 98% of the work and visibility done for the typical CUCM admin.  However, there always comes a time when getting under the hood can be helpful.  I’m not sure what to say… Examples! Log into the CLI and use the “run sql” command followed by your query.  Here are a few of the ones I have gotten started with. Show all of the tables in the DB: run … Continue reading

Posted in Collaboration | Tagged , , , | Leave a comment

Configure IOS DSP Conference Bridge

To configure a DSP conference bridge in IOS you will need to iron out a few sections of config in a particular order and then link it all together with the “associate” commands. First, configure SCCP on the box and reference the UCM system(s) in your environment !define a source !reference your UCM system(s) and prioritize them when using redundancy interfacesccp local GigabitEthernet0/0 sccp ccm 192.168.1.10 identifier 1 priority 1 version 7.0 Next, build out your dspfarm profile for this conference.  This is where you allocate resources and specify codecs that are supported !name it and indicate its a conference. … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

Taking a Screenshot on an 8800 Series Cisco Phone

Taking screenshots of the screen of Cisco IP phones can be helpful in remote troubleshooting and documentation. Taking screenshots of the latest 88xx phones is just as simple as in the past. Continue reading

Posted in Collaboration, Telephony | Tagged , , , , | Leave a comment

Calling Party Routing of Anonymous Calls SIP Header Fix Up

Cisco’s “Route Next Hop By Calling Party Number” translation pattern option has addressed the common question of “how do I route or block calls based on Caller ID?” since CUCM version 8. However, there still remains a limitation and that is how to deal with “Anonymous”, “Restricted” or “Unknown” Calling Numbers. The problem is that the SIP information actually lists this as part of the From header where CUCM typically would expect to see a numeric value. Continue reading

Posted in Collaboration, Telephony | Tagged , , , | Leave a comment