[cisco-voip] DP's nightmare

Tue Dec 18 08:58:17 EST 2012

Search this list, there is a cli command that exports the phones from the risdb into a csv file. Execute that command on every sub running the cm service.
Either Wes or Ryan is the sender of the email. 
I don't have access to my pc go give you the full command.

HTH

Ovidiu

Sent from my phone

On Dec 18, 2012, at 14:22, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:

> In CallManager, do a device search for phones, or whatever search you like. Change the result to provide 250 phones, this injects the results into the query you see in the URL. Then go into the address bar and make it larger. It takes a while, but eventually comes back. I wouldn't do more than 2000. 
> 
> Sent from my iPhone...
> 
> "There's no place like 127.0.0.1"
> 
> On Dec 18, 2012, at 8:10 AM, abbas Wali <abbaseo at gmail.com> wrote:
> 
>> Lelio - go to URL? sorry which URL. you mean in the CM!!
>> Thanks Ed, I am trying with the inventry app link you sent. lets see what happens.
>> besides who can be this 'someone' 
>> 
>> thanks all
>> 
>> 
>> On 18 December 2012 13:04, Ed Leatherman <ealeatherman at gmail.com> wrote:
>> Haha i knew someone would have a easier solution
>> 
>> 
>> On Tue, Dec 18, 2012 at 7:51 AM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:
>> To get this information I usually go to the URL and edit it to return 2000 entries, then cut and paste into a file. Do this four times and you've got your 7k phones. Import the file as tab delimited into Excel and you're good to go. 
>> 
>> Sent from my iPhone...
>> 
>> "There's no place like 127.0.0.1"
>> 
>> On Dec 18, 2012, at 7:44 AM, Ed Leatherman <ealeatherman at gmail.com> wrote:
>> 
>>> Hi Abbas,
>>> 
>>> I don't think BAT can export the IP Address; seems to me it only pulls things from the configuration database rather than run time info - would be happy to be proven wrong there though. I think you are on the right track otherwise - need a sorted list of device names so you can use BAT or some other mechanism to update with the new DP.
>>> 
>>> RTMT can bring up the IP's of phones, i'm not sure if you can export or copy/paste out of it into excel though.
>>> 
>>> Couple other "free" ways come to mind that could get you a list of device names with IP Addresses. 
>>> 
>>> You probably already know what IP Subnets these phones are all in - assuming that is the case you can use a tool like this one:
>>> http://sourceforge.net/projects/cipinventory/ 
>>> to scan those subnets and scrape the relevant information from the IP Phone's webpage. I've used the script before and it works well, but you might need to hack it a little bit to update for new phone models or something. This might be the best approach if you cant get RTMT or BAT to play nice.
>>> 
>>> Other way I can think of if you are comfortable with programming is to write a program yourself to use the SOAP interface to poll for IP's from call manager and write that to a file. Actually you could probably do the whole process including updating the DP's in once script. For something you use only once though, it might not be worth the time to write and test it unless you want to learn how to do it or are already really familiar with all the programming pieces.
>>> 
>>> You could probably screen scrape CDP neighbor information from all your switches if they're all cisco and get device name and IP address that way. 
>>> 
>>> Maybe someone else has a simpler idea. 
>>> 
>>> Ed
>>> 
>>> 
>>> On Tue, Dec 18, 2012 at 7:11 AM, abbas Wali <abbaseo at gmail.com> wrote:
>>> Guys, 
>>> 
>>> i have to sort out the Device pools. currently there is a mess. we have around 7k phone dispersed around generic meaningless DP's. 
>>> we now are implementing SRST and have come up with new site based DPs. 
>>> 
>>> my job is to locate the phones and put them in the new site specific DP. 
>>> I am clueless of where to start, may be we can download from BAT check and sort out by IP add in the Exl and insert back into CM just to correct the DP??
>>> 
>>> currently i get the below if i do a search for 7975's.
>>> 
>>> Cisco 7975	SEP081FF3623B4D	 Base Phone	Cisco 7975	Registered with 172.30.213.15	172.30.200.144
>>> Cisco 7975	SEP081FF3623B98	 Base Phone	Cisco 7975	Registered with 172.30.213.15	172.30.168.93
>>> Cisco 7975	SEP081FF3623C1A	 Base Phone	Cisco 7975	Registered with 172.30.213.15	172.30.200.155
>>> Cisco 7975	SEP081FF3623E21	 Base Phone	Cisco 7975	Registered with 172.30.213.15	172.30.200.68
>>> 
>>> any ideas!!!
>>> 
>>> Thanks
>>> -- 
>>> @bbas.. 
>>> 
>>> 
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>> 
>>> 
>>> 
>>> 
>>> -- 
>>> Ed Leatherman
>>> 
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> 
>> 
>> 
>> -- 
>> Ed Leatherman
>> 
>> 
>> 
>> 
>> -- 
>> @bbas.. 
>> 
> _______________________________________________
> 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/20121218/86411bc9/attachment.html>