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