This query lists the Media Resources, the associated MRG / MRGL, and spits out a NULL for a device which is not associated with any MRG – (a NULL value indicates the Media Resource is in the default MRG) run sql select Device.name, Device.description, MediaResourceGroup.name, MediaResourceList.name from Device left outer join MediaResourceGroupMember on Device.pkid = MediaResourceGroupMember.fkdevice left outer join MediaResourceListMember on MediaResourceListMember.fkmediaresourcegroup = MediaResourceGroupMember.fkmediaresourcegroup left outer join MediaResourceGroup on MediaResourceGroup.pkid =  MediaResourceListMember. fkmediaresourcegroup left outer join MediaResourceList on MediaResourceList.pkid = MediaResourceListMember.fkmediaresourcelist where ((tkmodel == 50) OR (tkmodel == 51) OR (tkmodel == 70) OR (tkmodel == 83) OR (tkmodel == 84) OR (tkmodel == 110) OR (tkmodel == 111) OR (tkmodel == 112) OR (tkmodel == 113) OR (tkmodel == 126)) order by MediaResourceList.Name Hope this helps. Thanks, David ... View more

Previous thread with helpful information on setting up Custom Alerts within RTMT https://supportforums.cisco.com/thread/312915 Hope this helps. ... View more

Cisco Call Detail Records Field Descriptions http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrfdes.html CDR Examples http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrex.html Table name as listed above "car:tbl_billing_data" Hope this helps. ... View more

You might try this: Search for "Cisco 7942" phone type run sql SELECT TypeModel.Name, Device.Name, Device.Description, DeviceNumPlanMap.Display, NumPlan.DNOrPattern, DeviceNumPlanMap.NumPlanIndex,  CallingSearchSpace.Name  FROM NumPlan INNER JOIN TypeModel INNER JOIN Device ON TypeModel.Enum = Device.tkModel INNER JOIN DeviceNumPlanMap ON Device.pkid = DeviceNumPlanMap.fkDevice ON NumPlan.pkid = DeviceNumPlanMap.fkNumPlan INNER JOIN CallingSearchSpace ON NumPlan.fkCallingSearchSpace_SharedLineAppear = CallingSearchSpace.pkid INNER JOIN RoutePartition ON NumPlan.fkRoutePartition = RoutePartition.pkid WHERE TypeModel.Name Like 'Cisco 7942' ORDER BY NumPlan.DNOrPattern Search not limited to phone type run sql SELECT TypeModel.Name, Device.Name, Device.Description,  DeviceNumPlanMap.Display, NumPlan.DNOrPattern,  DeviceNumPlanMap.NumPlanIndex,  CallingSearchSpace.Name  FROM NumPlan  INNER JOIN TypeModel INNER JOIN Device ON TypeModel.Enum =  Device.tkModel INNER JOIN DeviceNumPlanMap ON Device.pkid =  DeviceNumPlanMap.fkDevice ON NumPlan.pkid = DeviceNumPlanMap.fkNumPlan  INNER JOIN CallingSearchSpace ON  NumPlan.fkCallingSearchSpace_SharedLineAppear = CallingSearchSpace.pkid  INNER JOIN RoutePartition ON NumPlan.fkRoutePartition =  RoutePartition.pkid ORDER BY NumPlan.DNOrPattern Hope this helps. ... View more

Here is another option for you. Run the following from Command Line, copy/paste to notepad then import into Excel. run sql select numplan.dnorpattern, routepartition.name AS routepartitionname, numplan.description FROM numplan LEFT OUTER JOIN routepartition ON numplan.fkroutepartition = routepartition.pkid order by dnorpattern Hope this helps. ... View more

Here is the link to the software download. Cisco Unified IP Phone 7912G http://www.cisco.com/cisco/software/release.html?mdfid=278115698&catid=278875240&softwareid=282074289&release=8.0%284%29&relind=AVAILABLE&rellifecycle=&reltype=all ... View more