The SQL query below (CCM 3.2) lists most of the information for UDP's except CallPickup Group info that is displayed in the format 'A3-A6B3-CA61DC5DBDF7' instead of the real group names. Is there any way to fix this using a join command or similar?
dev.tkDeviceProfile as DP_or_Phone,
right(dev.name, 20) as UDP_Name,
right(dev.Description, 30) as Description,
right(dev.LoginUserID, 20) as Login_User_ID,
right(dev.AddOnModules, 20) as Expansion_Module,
right(num.DNOrPattern, 20) as Line_DN,
right(par.name, 20) as Line_Partition,
right(css.name, 20) as Line_CSS,
right(num.CFAdestination, 20) as Line_CFA_Dest,
right(num.CFBdestination, 20) as Line_CFB_Dest,
right(num.CFNAdestination, 20) as Line_CFNA_Dest,
right(num.ikNumPlan_CallPickupGroup, 20) as Call_Pickup_Grp,
right(dvn.Label, 30) as Line_Text_Label,
right(dvn.Display, 30) as Line_Display_CLID
from dbo.device as dev
inner join dbo.devicenumplanmap as dvn
on dev.pkid = dvn.fkDevice
inner join dbo.numplan as num
on dvn.fknumplan = num.pkid
inner join dbo.RoutePartition as par
on par.pkid = num.fkRoutePartition
inner join dbo.callingsearchspace as css
on css.pkid = num.fkCallingSearchSpace_SharedLineAppear
where dev.tkDeviceProfile = "2"
dev.tkDeviceProfile = "1"
-- "1" User UDP and is "2" is AutoGenerated UDP
and dev.AddOnModules = "0"
--and dev.Description != "%"
order by Line_DN