« Back to Administration XML Questions

How can I retrieve a list of Call Pickup Groups?

Combination View Flat View Tree View
Threads [ Previous | Next ]
How can I retrieve a list of Call Pickup Groups?

Specific requests for managing Call Pickup Groups are not available as of CallManager 5.1, however, the database can be queried directly via SQL to find the information:

For 4.1(3) onwards, use a query like the following to get the list of CallPickup Groups configured and the DNs associated.

"select pg.*, np.DNOrPattern from pickupgroup pg, Numplan np where pg.fknumplan_pickup=np.pkid"

-PickupGroup table contains name, description, notification etc.
-PickupGroupMember table contains associated CallPickupGroups.
-PickupGroupLineMap table contains the directory numbers associated with the CallPickupGroup.

For Callmanager versions prior to 4.1(3), then the following query would give the CallPickup numbers.

"select np.* from Numplan np where tkPatternUsage='4'"