How can I retrieve a list of Call Pickup Groups?

Version 1
    This document was generated from CDN thread

    Created by: David Nguyen on 12-06-2008 06:25:04 AM
    How can I retrieve a list of Call Pickup Groups?

    Subject: Re: How can I retrieve a list of Call Pickup Groups?
    Replied by: David Nguyen on 12-06-2008 06:27:07 AM
    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'"