09-10-2003 08:03 PM - edited 03-13-2019 01:33 AM
Can some please give me a SQL query or way to find out what phones are associated with what pick up numbers.Or how many phones are associated with a particular pick up number.In table Numplan there is a field ikNumPlan_CallpickpUpGroup ho to query and get number from the value ?
Version 3.1
Thanks
09-11-2003 06:46 PM
Hi,
Below is the method i have used to obtain the information...
Dont ask me how the strings are derived.
select * from NumPlan where tkPatternUsage = 4
This will give a list of call pick up group numbers.
This list can be seen in CM web pages.
Each ext in a pickup group is associated with a ikNumPlan_CallPickUpGroup string like 0A4926D1-DBA7-46BD-A399-D6DBE92EB045
To obtain the DN associated with ikNumPlan_CallPickUpGroup
Select pkid from NumPlan dNOrpattern = 5007
The result = ikNumPlan_CallPickUpGroup which in this case is 0A4926D1-DBA7-46BD-A399-D6DBE92EB045
You could then perform a query that uses fields dNOrPattern and ikNumPlan_CallPickUpGroup to obtain
a list of phones associated with a pick up group number.
select dNOrPattern,ikNumPlan_CallPickUpGroup from NumPlan where dNorPattern < 4999
and ikNumPlan_CallPickUpGroup = "0A4926D1-DBA7-46BD-A399-D6DBE92EB045"
dNOrPattern ikNumPlan_CallPickUpGroup
-------------------------------------------------- ------------------------------------
4145 0A4926D1-DBA7-46BD-A399-D6DBE92EB045
4134 0A4926D1-DBA7-46BD-A399-D6DBE92EB045
4139 0A4926D1-DBA7-46BD-A399-D6DBE92EB045
Allan Wells
09-12-2003 06:58 AM
I'm using CCM 3.3(2). In this version, finding phones that belong to a Call Pickup Group is easy. From CCM just select Device>>>Phone, then in the Find Phone Where pull-down-menu select Call Pickup Group and then press the Find button.
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: