How to find call pick up group members

[j.bilodeau]

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

[thomas.richter]

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.

[darren.staples]

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

[lwai]

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.