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

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

How to find call pick up group members

Does anyone know if there is a way to find all users (lines) associate with each call pick up numbers?

3 REPLIES
New Member

Re: How to find call pick up group members

Our NEC CCM project manager gave me this SQL query to find the call pickup members in the CCMXXXX database :

select p.dnorpattern, e.dnorpattern

from numplan e, numplan p

where e.iknumplan_callpickupgroup like p.pkid

order by p.dnorpattern, e.dnorpattern

The left column is the call pickup group and the right column are the stations in the pickup group.

New Member

Re: How to find call pick up group members

thanks

I tried this on our 7750 running CCM 3.2 (SQL 7)

but doesn't like the "numplan"

comes back with Invalid object name 'numplan'

I am not familar with CCM on NEC - using different DB ???

if so, would you happen to know the query statement for SQL 7.0

thanks

New Member

Re: How to find call pick up group members

Under each call pickup group member's phone configuration --> description define the call pickup number. eg. PG-3146.

While you want to sort out the members, try the following:

Find--> phone-->description-->contain-->PG3146.

All call pickup member will be listed.

442
Views
0
Helpful
3
Replies
CreatePlease login to create content