10-17-2007 03:41 PM - last edited on 03-25-2019 06:55 PM by ciscomoderator
Is there any way to have an sql query where i can capture the Primary line/DN/Line 1 along with the mac , description etc. HEre is waht i use so far
select NumPlan.DNOrPattern as DirectoryNumber, Device.Name as DeviceName, Device.Description as UserDeviceProfileName, Device.LoginUserid as UserId, DeviceNumPlanMap.Display as DisplayIntCallerID,DeviceNumPlanMap.Label as LineTextLabel,
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 device.tkmodel = typemodel.enum
and numplan.tkPatternUsage = 2
order by numplan.DnOrPattern
thanks
10-18-2007 05:50 AM
you're getting there. you will also need to reference devicenumplanmap.numplanindex so that you get the details of only the first line
... and devicenumplanmap.numplanindex = 1 ...
10-18-2007 08:37 AM
Thanks, I;ll try those parameters
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide