Call pickup numbers and phone association

[shaftstri]

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

[allan.wells]

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

[mcnerney]

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.