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,...

Cisco Call Detail Records Field Descriptionshttp://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrfdes.htmlCDR Exampleshttp://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrex.htmlTable name as listed abo...

You might try this:Search for "Cisco 7942" phone typerun sql SELECT TypeModel.Name, Device.Name, Device.Description, DeviceNumPlanMap.Display, NumPlan.DNOrPattern, DeviceNumPlanMap.NumPlanIndex,  CallingSearchSpace.Name  FROM NumPlan INNER JOIN TypeM...

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 routepart...

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