<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><base href="x-msg://3655/"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Not to be that way, but I’m curious how you crammed 300 phones into a subnet that suppors 254 hosts. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Sorry…couldn’t help myself </span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'>James Buchanan</span></b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>|</span><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> UC Technology Manager </span></b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>|</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> <b>Presidio South </b></span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>|</span><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> Presidio Networked Solutions </span></b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'><o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'>12 Cadillac Dr Ste 130 Brentwood, TN 37027 </span></b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>|</span><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> </span></b><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="mailto:jbuchanan@presidio.com"><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>jbuchanan@presidio.com</span></a></span></b><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#548DD4'><o:p></o:p></span></b></p><p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'>D: 615-866-5729</span></b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> </span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>|</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'> <b>F:615-866-5781</b> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="http://www.presidio.com/" title="blocked::http://www.presidio.com/"><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>www.presidio.com</span></b></a><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Stephen Welsh<br><b>Sent:</b> Monday, January 23, 2012 6:41 PM<br><b>To:</b> Jason Aarons (AM)<br><b>Cc:</b> cisco-voip (cisco-voip@puck.nether.net)<br><b>Subject:</b> Re: [cisco-voip] Callmanager 8.5 SQL select to find IP Address of Phones?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Jason,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Wes covered this one previously:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="http://www.gossamer-threads.com/lists/cisco/voip/152439">http://www.gossamer-threads.com/lists/cisco/voip/152439</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Basically use the following from the UCM CLI:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><b>show risdb query phone </b><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>You can send to a file for download<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Here is a sample output:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal>DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp <o:p></o:p></p></div><div><p class=MsoNormal>SEPC471FE90B196, SEPC471FE90B196, 10.10.85.11, , 3, 0, C471FE90B196, reg, SCCP, 496, yes, 0, 383, NoUserId, 1, 1327068831, 1, SCCP69xx.9-2-2-6, SCCP69xx.9-2-2-6, , , , 0, , 1327068831<o:p></o:p></p></div><div><p class=MsoNormal>SEP5475D02AF886, SEP5475D02AF886, 10.10.85.12, , 3, 0, 5475D02AF886, reg, SCCP, 497, yes, 0, 384, NoUserId, 2, 1326985941, 1, SCCP69xx.9-2-2-6, SCCP69xx.9-2-2-6, , , , 0, , 1326985941<o:p></o:p></p></div><div><p class=MsoNormal>SEP000000000001, SEP000000000001, 192.168.254.253, , 0, 0, 000000000001, reg, SIP, 374, no, 0, 273, NoUserId, 3, 1327345013, 1, , , , , , 0, , 1327345013<o:p></o:p></p></div><div><p class=MsoNormal>SEPB8BEBF9D2145, SEPB8BEBF9D2145, 10.10.85.9, , 3, 0, B8BEBF9D2145, reg, SCCP, 435, yes, 0, 334, NoUserId, 4, 1327076856, 1, SCCP45.9-1-1SR1S, SCCP45.9-1-1SR1S, , , , 0, , 1327076856<o:p></o:p></p></div><div><p class=MsoNormal>SEPB8BEBF222CAF, SEPB8BEBF222CAF, 10.10.85.10, , 3, 0, B8BEBF222CAF, reg, SCCP, 435, yes, 0, 334, NoUserId, 5, 1327076855, 1, SCCP45.9-1-1SR1S, SCCP45.9-1-1SR1S, , , , 0, , 1327076855<o:p></o:p></p></div><div><p class=MsoNormal>SEP001C58F9EA67, SEP001C58F9EA67, 10.10.85.8, , 3, 0, 001C58F9EA67, reg, SCCP, 30018, yes, 0, 30044, ssmith, 6, 1327143304, 1, SCCP41.9-2-1S, SCCP41.9-2-1S, , , , 0, , 1327143304<o:p></o:p></p></div><div><p class=MsoNormal>SEP000ED7ABFE5E, SEP000ED7ABFE5E, 10.10.85.14, , 3, 0, 000ED7ABFE5E, reg, SCCP, 30006, yes, 0, 30018, NoUserId, 7, 1327281348, 1, SCCP70.9-2-1S, SCCP70.9-2-1S, , , , 0, , 1327281348<o:p></o:p></p></div><div><p class=MsoNormal>SEP001BD4604358, SEP001BD4604358, 10.10.85.4, , 3, 0, 001BD4604358, reg, SCCP, 30018, yes, 0, 30044, NoUserId, 8, 1327143305, 1, SCCP41.9-2-1S, SCCP41.9-2-1S, , , , 0, , 1327143305<o:p></o:p></p></div><div><p class=MsoNormal>SEP081735D4794F, SEP081735D4794F, 10.10.85.1, , 0, 0, 081735D4794F, reg, SIP, 493, yes, 0, 380, NoUserId, 9, 1327076912, 1, sip9971.9-2-3-27, sip9971.9-2-3-27, sip9971.9-2-2SR1-9, , , 0, , 1327076912<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><p class=MsoNormal>Thanks<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Stephen<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On 24 Jan 2012, at 00:19, Jason Aarons (AM) wrote:<o:p></o:p></p></div><p class=MsoNormal><br><br><o:p></o:p></p><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>In RTMT I can find the ip address of a phone, but I can’t find a way to export to csv,etc.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>So is there a select * from command I can run from CallManager CLI to get a list of phones and ip addresses? I can capture CLI output to .txt and make a .csv ? or AXL?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>I need to move all phones in 10.214.89.0/24 to a different Device Pool for SRST purposes, and can’t find an easy way based on IP Address. It’s roughly 300 phones.<o:p></o:p></span></p></div><p class=MsoNormal>_______________________________________________<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">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>