Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pick Up Group Name

Status
Not open for further replies.

Planetmaker

Technical User
Oct 18, 2006
224
GB
Since our recent upgrade from 4.0 to 4.2 I have noticed that the Call Pickup Group Name seems to have replaced the Description column. It looks like the new name has been created by combining the Call Pickup Group Number and Partition field ie 1050_Internal.
Therefore when we add a new user/dn we cannot easily determine which section/dept has what pickup group other by picking a user in the group and seeing what their group pickup is and then adding it for the new user.
I'd like to go through and rename them all to make it easier. We have backups of our v 4.0 but for some reason on our test network we cannot logon to the admin pages! The v 4.0 had MLA set up but none of the user names work and neither does the CCM Admin username. Any advice ?
The only other thing I can think is that there must be a record of the Pickup groups description in a word document or similar that I could access but I don't know where I should look.
 
You could use an SQL-query (if your old server is still working) to find the Call Pickup groups and the discriptions:

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top