[cisco-voip] easiest way to dump and search CallManager configuration for specific targets

[Anthony Holloway]

Let's say you wanted to find all translation patterns where the calling
party transformation was set to '2000'.

SSH to the publisher and run this command.

run sql select n.dnorpattern, p.name, n.callingpartytransformation from
numplan as n left join routepartition as p on n.fkroutepartition = p.pkid
where callingpartytransformation = '2000'

This can be pretty powerful. Just read the data dictionary to understand
the tables and their columns.

On Friday, March 28, 2014, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:

> This gives us what we need. But wow. It sure took a long time to produce
> the report. I don't even think I selected everything. The longest was the
> phones. About 9000 records took over 12 hours I think.
>
> Is there a way to retrieve the file aside from using the GUI?
>
>
> Sent from my iPhone
>
> On 2014-03-27, at 4:33 PM, "Heim, Dennis" <Dennis.Heim at wwt.com<javascript:_e(%7B%7D,'cvml','Dennis.Heim at wwt.com');>>
> wrote:
>
> Doing and export of the translation patterns under import/export will give
> you what you want.
>
>
>
> *Dennis Heim | Solution Architect (Collaboration)*
>
> World Wide Technology, Inc. | 314-212-1814
>
>
>
> *PS Engineering: ** Innovate & Ignite.*
>
>
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net<javascript:_e(%7B%7D,'cvml','cisco-voip-bounces at puck.nether.net');>]
> *On Behalf Of *Lelio Fulgenzi
> *Sent:* Thursday, March 27, 2014 3:21 PM
> *To:* cisco-voip voyp list
> *Subject:* [cisco-voip] easiest way to dump and search CallManager
> configuration for specific targets
>
>
>
>
> Just wondering what would be the easiest way to dump the CallManager
> configuration so I can search for specific targets?
>
> For example, you can search for a specific translation, but not the target.
>
> Thoughts? Will the Export/Import tool give me what I need?
>
> Lelio
>
> ---
> Lelio Fulgenzi, B.A.
> Senior Analyst, Network Infrastructure
> Computing and Communications Services (CCS)
> University of Guelph
>
> 519‐824‐4120 Ext 56354
> lelio at uoguelph.ca <javascript:_e(%7B%7D,'cvml','lelio at uoguelph.ca');>
> www.uoguelph.ca/ccs
> Room 037, Animal Science and Nutrition Building
> Guelph, Ontario, N1G 2W1
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140329/f8f7f8e5/attachment.html>