[cisco-voip] Gaps in my DID range

[Justin Kennedy]

I think this what you want to do. It's an SQL query performed directly from the database. I needed the same tool about a year ago. Good news - we had to upgrade the OS and CCM version from 4.2.1 to 4.2.3 to do complete the ODBC query.



Let me know if it runs for you...


SELECT     Device.Name, Device.Description, NumPlan.DNOrPattern
FROM       Device INNER JOIN
           DeviceNumPlanMap ON Device.pkid = DeviceNumPlanMap.fkDevice INNER JOIN
           NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid
ORDER BY Device.Name

Need the "Sort Type" to be just like this to see all numbers on each remote.





[cid:image002.jpg at 01C8ECE9.78AF5230]







Justin Kennedy

Stallion Oilfield Services

StaRComm VSAT Administrator





-----Original Message-----
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Erik Stillman
Sent: Wednesday, July 23, 2008 5:14 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Gaps in my DID range



Hi



Is there a table where the Directory Numbers are stored in Cisco CM version 4.2(3)?



We would like to access the database and run a report on all numbers used and dump it into Excel.





Thanks!





***********************************************************************



This communication is not intended to be used, and cannot be used,

by the recipient or any other person for the purpose of avoiding United

States federal tax penalties that may be imposed on the recipient or

such other person. In addition, if any United States federal tax

advice contained in this communication is used or referred to in

promoting, marketing or recommending any corporation, partnership

or other entity, investment plan, concept, structure or arrangement

(which should be assumed to be the case by a recipient or other

person who is not our client with respect to the subject matter of the

communication), then (i) such tax advice should be construed as written

to support the promotion or marketing of the transactions or matters

addressed by the advice and (ii) the recipient or other person should

seek advice based on the recipient or other person's particular

circumstances from an independent tax advisor. For further information,

please go to http://www.shearman.com/disclaimer/tax_disclosure.html



***********************************************************************



This transmittal and/or attachments may be a confidential

attorney-client communication or may otherwise be privileged or

confidential. If you are not the intended recipient, you are hereby

notified that you have received this transmittal in error; any review,

dissemination, distribution or copying of this transmittal is strictly

prohibited. If you have received this transmittal and/or attachments in

error, please notify us immediately by reply or by telephone (call us

collect at +1 212-848-8400) and immediately delete this message and

all its attachments.



Shearman & Sterling LLP is a limited liability partnership organized in

the United States under the laws of the State of Delaware, which laws

limit the personal liability of partners.

_______________________________________________

cisco-voip mailing list

cisco-voip at puck.nether.net

https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080723/baeef184/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 141609 bytes
Desc: image002.jpg
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080723/baeef184/attachment-0001.jpg>