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,
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?
But I only get something like this as a result:
Any Hints ?
Please excuse me if this doesn't help as I know nothing about SQL :) But I did see this post;
Hope this helps!
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: