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

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

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