[cisco-voip] What table field in CM?

[Eric Butcher]

The info  you're looking for are in two different tables.

Numplan contains DN specific items, such as the alerting name.
Devicenumplanmap contains things like display name, line text label, etc. (the "line appearance" stuff)

Numplan encompasses more than just DN's... it contains Route Patterns, translation patterns, DNs, etc.


Eric Butcher
Cisco Unified Communications Engineer
CDW Professional Services
11711 N Meridian, Ste 225
Carmel, IN  46032
* 317.569.4282 - IP Phone
* 765.744.1458 - Mobile
* eric.butcher at cdw.com<mailto:eric.butcher at cdw.com>
http://www.cdw.com/


From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Scott Voll
Sent: Tuesday, October 26, 2010 6:01 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] What table field in CM?

if I'm doing an SQL query on a CM 7.1.5 box what would the table / fields be for:  DN and Alerting name?  and/or User and telephone

Thanks

Scott
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101026/59b451f9/attachment.html>