Click here to request your free 14-day trial of Cisco Umbrella through NetCraftsmen today!

12/17
2008
William Bell

CUCM 6.x Database Schema Change – Call Forwarding

For those of you who either like to run queries on the Call Manager, have customers who do so, or have tools that customers use for change management and the like, please note that I just stumbled on a change to the CUCM 6.x database structure as it relates to call forwarding. 

 

The change is that forward destination information (i.e. the number a person forwards a call to) is no longer stored directly in the NumPlan table, though there is a call forward all branch of columns which I am still trying to piece together. The call forward destination information is now stored in the callforwarddynamic table. So, to find out if a phone is call forwarding a line to a long distance location (we do this in our health assessment, aka toll fraud (possibly)) instead of:

/*query for cucm 4.x*/

select n.dNorPattern as ‘pattern’,rp.name as ‘routePartitionName’,n.cFAVoiceMailEnabled as ‘callForwardAll.forwardToVoiceMail’, n.cFADestination as ‘callForwardAll.destination’

from NumPlan as n
 

where ((n.cFADestination like ‘91%’) or (n.cFADestination like ‘9011%’))

You need to query multiple tables

/*query for cucm 6.x and later*/:

select n.dNorPattern as pattern, cfd.cfadestination

from NumPlan as n inner join callforwarddynamic as cfd on cfd.fkNumPlan=n.pkid

where (cfd.cfadestination like ‘91%’) or (cfd.cfadestination like ‘9011%’))

This isn’t too much of a problem, but it does make queries targeting calling search space configurations on call forward destinations (i.e. to detect possible toll fraud opportunities) a little more complicated with multiple joins.More importantly, if you had a routine that was checking for this either on a regular basis or as part of a configuration/optimization exercise and you have updated to 6.x, some changes are necessary.

Regards, Bill

Posted Oct 6, 2008, 4:51 PM by wjb

William Bell

William Bell

Architect, Infrastructure Practice Lead

William’s background spans an array of technical disciplines including application development, network infrastructure, protocol analysis, virtualization, and Unified Communications. Bill is certified as a CCIE Voice (CCIE #38914) and possesses a deep understanding of Cisco’s UC and Collaboration portfolio. He leads the Infrastructure Engineering team and also works with customers on architecting solutions that align with core business drivers. Bill is a regular contributor on the Cisco Support Community, a 3 time Cisco Designated VIP, and blogs on the NetCraftsmen and UC Guerrilla sites.

View more Posts

 

Nick Kelly

Cybersecurity Engineer, Cisco

Nick has over 20 years of experience in Security Operations and Security Sales. He is an avid student of cybersecurity and regularly engages with the Infosec community at events like BSides, RVASec, Derbycon and more. The son of an FBI forensics director, Nick holds a B.S. in Criminal Justice and is one of Cisco’s Fire Jumper Elite members. When he’s not working, he writes cyberpunk and punches aliens on his Playstation.

 

Virgilio “BONG” dela Cruz Jr.

CCDP, CCNA V, CCNP, Cisco IPS Express Security for AM/EE
Field Solutions Architect, Tech Data

Virgilio “Bong” has sixteen years of professional experience in IT industry from academe, technical and customer support, pre-sales, post sales, project management, training and enablement. He has worked in Cisco Technical Assistance Center (TAC) as a member of the WAN and LAN Switching team. Bong now works for Tech Data as the Field Solutions Architect with a focus on Cisco Security and holds a few Cisco certifications including Fire Jumper Elite.

 

John Cavanaugh

CCIE #1066, CCDE #20070002, CCAr
Chief Technology Officer, Practice Lead Security Services, NetCraftsmen

John is our CTO and the practice lead for a talented team of consultants focused on designing and delivering scalable and secure infrastructure solutions to customers across multiple industry verticals and technologies. Previously he has held several positions including Executive Director/Chief Architect for Global Network Services at JPMorgan Chase. In that capacity, he led a team managing network architecture and services.  Prior to his role at JPMorgan Chase, John was a Distinguished Engineer at Cisco working across a number of verticals including Higher Education, Finance, Retail, Government, and Health Care.

He is an expert in working with groups to identify business needs, and align technology strategies to enable business strategies, building in agility and scalability to allow for future changes. John is experienced in the architecture and design of highly available, secure, network infrastructure and data centers, and has worked on projects worldwide. He has worked in both the business and regulatory environments for the design and deployment of complex IT infrastructures.