Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Call pickup numbers and phone association

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


New Member

Re: Call pickup numbers and phone association


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


Re: Call pickup numbers and phone association

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.