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

2014-03-30 Thread Lelio Fulgenzi
Definitely. Very powerful. But for now, I'd like to stick with the default export results and begin a snapshot. It would be easier if I could get them automatically. I could (try to) use curl with userid/password, but not sure if the tar file name follows a structure or not. Will have to

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

2014-03-30 Thread Heim, Dennis
Uplinx makes a nice report tools that exports it all to excel and other various formats. Dennis Heim | Solution Architect (Collaboration) World Wide Technology, Inc. | 314-212-1814 PS Engineering: Innovate Ignite. From: Lelio Fulgenzi [mailto:le...@uoguelph.ca] Sent: Sunday, March 30, 2014

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

2014-03-30 Thread Lelio Fulgenzi
Yes, I've seen Uplinx. They're pretty good. Wonder if they have an SQL query builder built in for custom reports. Lelio Sent from my iPhone On 2014-03-30, at 4:30 PM, Heim, Dennis dennis.h...@wwt.com wrote: Uplinx makes a nice report tools that exports it all to excel and other various

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

2014-03-29 Thread 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 =

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

2014-03-28 Thread Lelio Fulgenzi
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

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

2014-03-27 Thread Lelio Fulgenzi
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,