Call Manager SQL Report Help

Unanswered Question
Mar 10th, 2008
User Badges:

Thanks to many of yo here i have been able to run a SQL report that shows each phone along with the primary/ first line.


SELECT DISTINCT Device.Name, Device.Description, NumPlan.DNOrPattern, DeviceNumPlanMap.Display, DeviceNumPlanMap.E164Mask,CFNAVoiceMailEnabled

FROM Device INNER JOIN

DeviceNumPlanMap ON Device.pkid = DeviceNumPlanMap.fkDevice INNER JOIN

NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid

WHERE (DeviceNumPlanMap.NumPlanIndex = 1)


Does anyone know how i could also get the Set type and Device pool in the same query?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion