cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
223
Views
0
Helpful
2
Replies

Call pickup numbers and phone association

shaftstri
Level 1
Level 1

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

2 Replies 2

allan.wells
Level 3
Level 3

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

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.

Getting Started

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: