[cisco-voip] Callmanager 8.5 SQL select to find IP Address of Phones?

[Buchanan, James]

Not to be that way, but I'm curious how you crammed 300 phones into a subnet that suppors 254 hosts.

Sorry...couldn't help myself :)

James Buchanan| UC Technology Manager | Presidio South | Presidio Networked Solutions
12 Cadillac Dr Ste 130 Brentwood, TN 37027 | jbuchanan at presidio.com<mailto:jbuchanan at presidio.com>
D: 615-866-5729 | F:615-866-5781  www.presidio.com<http://www.presidio.com/>

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Stephen Welsh
Sent: Monday, January 23, 2012 6:41 PM
To: Jason Aarons (AM)
Cc: cisco-voip (cisco-voip at puck.nether.net)
Subject: Re: [cisco-voip] Callmanager 8.5 SQL select to find IP Address of Phones?

Jason,

Wes covered this one previously:

http://www.gossamer-threads.com/lists/cisco/voip/152439

Basically use the following from the UCM CLI:

show risdb query phone

You can send to a file for download

Here is a sample output:

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
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
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
SEP000000000001, SEP000000000001, 192.168.254.253, , 0, 0, 000000000001, reg, SIP, 374, no, 0, 273, NoUserId, 3, 1327345013, 1, , , , , , 0, , 1327345013
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
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
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
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
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
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

Thanks

Stephen

On 24 Jan 2012, at 00:19, Jason Aarons (AM) wrote:


In RTMT I can find the ip address of a phone, but I can't find a way to export to csv,etc.

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?


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.
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto: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/20120123/d412df7d/attachment.html>