List members of a Pickup Group 1

[gmail2]

We've just moved over to call manager after having a meridian for years. We have extension mobility enabled, so users log onto whichever phone they need to work at (although in general this doesn't change that much). However, I can't find a way to find out who is in a particular pick up group. If I go to phones, and search for phones in a certain pickup group - it will tell me which phones that users from that pickup group are logged into. But it won't tell me the actual users that are logged into the phones unless I click on each one individually. Can anybody help with this at all?

Irish Poetry - Karen O'Connor
Get your Irish Poetry Published
Garten und Landschaftsbau

 

[iptuser]

The best way is to go to each PUG and look for the dependancies

 

[gmail2]

Thanks for that iptuser - still not perfect as it lists them more than once if the lines appear on other phones - but it's the best we've got I guess !!!!!

Irish Poetry - Karen O'Connor
Get your Irish Poetry Published
Garten und Landschaftsbau

 

[Dtravler]

You can Query the SQL database!

Query list of members of Call Pickup Groups
-------------------------------------------
SELECT PickupGroup.Name AS [Call Pickup Group Name], NumPlan.DNOrPattern AS Members

FROM PickupGroup INNER JOIN

PickupGroupMember ON PickupGroup.pkid = PickupGroupMember.fkPickupGroup_Primary AND

PickupGroup.pkid = PickupGroupMember.fkPickupGroup_Member INNER JOIN

PickupGroupLineMap ON PickupGroup.pkid = PickupGroupLineMap.fkPickupGroup INNER JOIN

NumPlan ON PickupGroupLineMap.fkNumPlan_Line = NumPlan.pkid

ORDER BY PickupGroup.Name

Query list of Call Pickup Groups
--------------------------------
SELECT NumPlan.Description, NumPlan.DNOrPattern, RoutePartition.Name AS Partition

FROM NumPlan INNER JOIN

RoutePartition ON NumPlan.fkRoutePartition = RoutePartition.pkid

WHERE (NumPlan.tkPatternUsage = 4)

ORDER BY NumPlan.DNOrPattern


Hope this helps.