CCM SQL Query - CallPickup group info for Director Numbers
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
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...