SQL Question on 4.1(3) Calling Search Space

Unanswered Question
Oct 31st, 2008
User Badges:

Dear all,

I am already using succesfully multiple SQL Querys to gather Information from the call manager but I would like to optimize another query.

Basically I would like to check if certain extension have been assigned the correct Calling Search Space.

I use the below and even get the Device Pool:

select NumPlan.DNOrPattern as DirectoryNumber, Device.Name as DeviceName, Device.Description as


Device.LoginUserid as UserId,

DeviceNumPlanMap.Display as DisplayIntCallerID,

DeviceNumPlanMap.tkRingSetting as Ringsetting,

DeviceNumPlanMap.NumPlanIndex as NumPlanIndex,

DeviceNumPlanMap.Label as LineTextLabel,

numplan.alertingname as AlertingName,

DeviceNumPlanMap.MaxNumCalls, DeviceNumPlanMap.BusyTrigger,

TypeModel.Name AS PhoneType, DeviceNumPlanMap.E164Mask as ExtPhoneMask, NumPlan.CFADestination as

CallFWDALL, NumPlan.CFNADestination as CallFWDNoAnswer, NumPlan.CFBDestination as CallFWDBusy,

devicepool.Name as DevPoolName from numplan, devicenumplanmap, devicepool, device ,TypeModel

where DeviceNumPlanMap.fknumplan = numplan.pkid

and DeviceNumPlanMap.fkdevice = device.pkid and device.fkdevicepool = devicepool.pkid and TypeModel.Name = 'Cisco 7970' and numplan.tkPatternUsage = 2

order by numplan.DnOrPattern

But how would I get the Calling Search Space?

I added


as CSS

But I only get something like this as a result:


Any Hints ?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Rob Huffman Fri, 10/31/2008 - 07:23
User Badges:
  • Super Red, 40000 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications


This Discussion