<html><head><base href="x-msg://3655/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Jason,<div><br></div><div>Wes covered this one previously:</div><div><br></div><div><a href="http://www.gossamer-threads.com/lists/cisco/voip/152439">http://www.gossamer-threads.com/lists/cisco/voip/152439</a></div><div><br></div><div>Basically use the following from the UCM CLI:</div><div><br></div><div><b>show risdb query phone </b></div><div><br></div><div>You can send to a file for download</div><div><br></div><div>Here is a sample output:</div><div><br></div><div><div>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 </div><div>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</div><div>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</div><div>SEP000000000001, SEP000000000001, 192.168.254.253, , 0, 0, 000000000001, reg, SIP, 374, no, 0, 273, NoUserId, 3, 1327345013, 1, , , , , , 0, , 1327345013</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div><br></div></div><div>Thanks</div><div><br></div><div>Stephen</div><div><br><div><div>On 24 Jan 2012, at 00:19, Jason Aarons (AM) wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-US" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; 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></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; 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></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; 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></div></div>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" style="color: blue; text-decoration: underline; ">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" style="color: blue; text-decoration: underline; ">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div></blockquote></div><br></div></body></html>