<html><head></head><body bgcolor="#FFFFFF"><div>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.</div><div>Either Wes or Ryan is the sender of the email. </div><div>I don't have access to my pc go give you the full command.</div><div><br></div><div>HTH</div><div><br></div><div>Ovidiu</div><div><br></div><div>Sent from my phone<br><br><div><br></div></div><div><br>On Dec 18, 2012, at 14:22, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca">lelio@uoguelph.ca</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div>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. <br><br>Sent from my iPhone...<div><br></div><div>"There's no place like 127.0.0.1"</div></div><div><br>On Dec 18, 2012, at 8:10 AM, abbas Wali <<a href="mailto:abbaseo@gmail.com">abbaseo@gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>Lelio - go to URL? sorry which URL. you mean in the CM!!<br>Thanks Ed, I am trying with the inventry app link you sent. lets see what happens.<br>besides who can be this 'someone' <br><br>thanks all<br><br><br><div class="gmail_quote">
On 18 December 2012 13:04, Ed Leatherman <span dir="ltr"><<a href="mailto:ealeatherman@gmail.com" target="_blank">ealeatherman@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Haha i knew someone would have a easier solution<div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">On Tue, Dec 18, 2012 at 7:51 AM, Lelio Fulgenzi <span dir="ltr"><<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF"><div>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. <br>
<br>Sent from my iPhone...<div><br></div><div>"There's no place like 127.0.0.1"</div></div><div><div><div><br>On Dec 18, 2012, at 7:44 AM, Ed Leatherman <<a href="mailto:ealeatherman@gmail.com" target="_blank">ealeatherman@gmail.com</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div>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/" target="_blank">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><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" target="_blank">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>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>cisco-voip mailing list</span><br><span><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></span><br>
<span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br></div></blockquote></div></div></div></blockquote></div><br><br clear="all">
<div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br>Ed Leatherman<br><br>
</font></span></div>
</blockquote></div><br><br clear="all"><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>
</div></blockquote></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>cisco-voip mailing list</span><br><span><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></span><br><span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br></div></blockquote></body></html>