I have a customer who would like to list all Pickup groups with the assoicated users.
is it possible to Query, List and Extract information from the Publisher.
Well.. your subject did say CUCM7....
That said, my syntax was wrong; I wrote that query in McDonalds after too many coffees and without a CCM to test against; sorry!
Try this (tested):
run sql select n.dnorpattern, n.description, pg.name as PickupName from numplan n join pickupgrouplinemap pglm on n.pkid = pglm.fknumplan_line join pickupgroup pg on pglm.fkpickupgroup = pg.pkid