Hi Abbas,<div><br></div><div>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.</div>
<div><br></div><div>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.</div><div><br></div><div>Couple other "free" ways come to mind that could get you a list of device names with IP Addresses. </div>
<div><br></div><div>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:</div><div><a href="http://sourceforge.net/projects/cipinventory/">http://sourceforge.net/projects/cipinventory/</a> <br>
</div><div>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.</div>
<div><br></div><div>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.</div>
<div><br></div><div>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. </div><div><br></div><div>Maybe someone else has a simpler idea. </div>
<div><br></div><div>Ed</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Dec 18, 2012 at 7:11 AM, abbas Wali <span dir="ltr"><<a href="mailto:abbaseo@gmail.com" target="_blank">abbaseo@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Guys, <br><br>i have to sort out the Device pools. currently there is a mess. we have around 7k phone dispersed around generic meaningless DP's. <br>
we now are implementing SRST and have come up with new site based DPs. <br>
<br>my job is to locate the phones and put them in the new site specific DP. <br>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??<br>
<br>currently i get the below if i do a search for 7975's.<br><br>
<table border="0" cellpadding="0" cellspacing="0" width="778"><colgroup><col style="width:53pt" width="70">
<col style="width:93pt" width="124">
<col style="width:167pt" width="223">
<col style="width:53pt" width="70">
<col style="width:146pt" width="194">
<col style="width:73pt" width="97">
</colgroup><tbody><tr style="min-height:15.0pt" height="20">
<td style="min-height:15.0pt;width:53pt" height="20" width="70">Cisco 7975</td>
<td style="width:93pt" width="124">SEP081FF3623B4D</td>
<td style="width:167pt" width="223"> Base Phone</td>
<td style="width:53pt" width="70">Cisco 7975</td>
<td style="width:146pt" width="194">Registered with 172.30.213.15</td>
<td style="width:73pt" width="97">172.30.200.144</td>
</tr>
<tr style="min-height:15.0pt" height="20">
<td style="min-height:15.0pt" height="20">Cisco 7975</td>
<td>SEP081FF3623B98</td>
<td> Base Phone</td>
<td>Cisco 7975</td>
<td>Registered with 172.30.213.15</td>
<td>172.30.168.93</td>
</tr>
<tr style="min-height:15.0pt" height="20">
<td style="min-height:15.0pt" height="20">Cisco 7975</td>
<td>SEP081FF3623C1A</td>
<td> Base Phone</td>
<td>Cisco 7975</td>
<td>Registered with 172.30.213.15</td>
<td>172.30.200.155</td>
</tr>
<tr style="min-height:15.0pt" height="20">
<td style="min-height:15.0pt" height="20">Cisco 7975</td>
<td>SEP081FF3623E21</td>
<td> Base Phone</td>
<td>Cisco 7975</td>
<td>Registered with 172.30.213.15</td>
<td>172.30.200.68</td>
</tr>
</tbody></table><br clear="all">any ideas!!!<br><br>Thanks<span class="HOEnZb"><font color="#888888"><br>-- <br><font style="font-family:comic sans ms,sans-serif;color:rgb(51,102,255)" size="4"><span style="color:rgb(0,0,153)">@bbas.. </span><br>
<span><span style="background-color:rgb(255,0,0)"></span></span></font><br>
</font></span><br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Ed Leatherman<br><br>
</div>