Have you ever had to try and find out which phone is in which hunt group in Cisco Commination Manager?
Well here is a little hacky way of getting the info
From the console run this command
run sql select n.dnorpattern as Ext_Number,n.fkroutepartition,pgn.dnorpattern as PG_Number ,p.name from pickupgrouplinemap pglm join numplan n on n.pkid = pglm.fknumplan_line join pickupgroup p on p.pkid = pglm.fkpickupgroup join numplan pgn on p.fknumplan_pickup = pgn.pkid
This should get you around the dependency records bug, if you are hitting this of course.
Nice !!!
