<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)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:Consolas;
panose-1:2 11 6 9 2 2 4 3 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";
color:black;}
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.content
{mso-style-name:content;}
span.EmailStyle24
{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 bgcolor=white 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'>There is the axl serviceability API that gets you into RIS<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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Dennis Heim<br>Network Voice Engineer<br>CDW Advanced Technology Services<br>11711 N. Meridian Street, Suite 225<br>Carmel, IN 46032<br><br>317.569.4255 Office<br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>317.569.4201 Fax<br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>317.694.6070 Cell<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="mailto:dennis.heim@cdw.com" title="mailto:dennis.heim@berbee.com">dennis.heim@cdw.com</a><br><a href="http://www.berbee.com/" title="http://www.berbee.com/">www.berbee.com</a></span><span style='color:#1F497D'><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";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Vince Loschiavo<br><b>Sent:</b> Wednesday, April 14, 2010 8:53 AM<br><b>To:</b> Wes Sisk; Frank Arrasmith<br><b>Cc:</b> cisco-voip@puck.nether.net<br><b>Subject:</b> Re: [cisco-voip] Cisco IP Phone inventory tool - New version announced - Testers needed<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'>Thanks for the heads up on the “show risdb query phone”.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'>Do you know off hand if you can query the RIS Database via the AXL/SOAP interface or if AXL/SOAP is just for the Informix database and not the </span><span class=content><span style='font-family:"Calibri","sans-serif"'>Real-Time Information Server </span></span><span style='font-family:"Calibri","sans-serif";color:windowtext'>db?<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'>Cheers!<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:11.0pt;font-family:"Arial","sans-serif"'>Vincent Loschiavo</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><br></span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#7F7F7F'>Director of Consulting Services<br></span></b><b><span style='font-size:11.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>DATACORP</span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#7F7F7F'><br></span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>8200 N.W. 41st Street, Suite 130</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br></span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>Miami, FL 33166</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br></span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#788D1F'>Ofc: </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>954-671-5669</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br></span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#788D1F'>Cell:</span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D'> </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>786-282-1164<br></span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#788D1F'>Fax:</span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D'> </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'>888-767-5905<br></span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#788D1F'>Email:</span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D'> </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#0084A8'><a href="mailto:dfowler@data-corporation.com"><span style='color:#0084A8'>vloschiavo@data-corporation.com</span></a><br><br></span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><img border=0 width=325 height=42 id="Picture_x0020_1" src="cid:image001.gif@01CADBB0.9B5DC020" alt=datacorp-325x42.gif><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><img border=0 width=75 height=75 id="Picture_x0020_2" src="cid:image002.gif@01CADBB0.9B5DC020" alt="ccvp_voice_sm"><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";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> Wes Sisk [mailto:wsisk@cisco.com] <br><b>Sent:</b> Tuesday, April 13, 2010 2:14 PM<br><b>To:</b> Frank Arrasmith<br><b>Cc:</b> Vince Loschiavo; cisco-voip@puck.nether.net<br><b>Subject:</b> Re: [cisco-voip] Cisco IP Phone inventory tool - New version announced - Testers needed<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>'ephone' is a CME entity. It is most likely an IOS command.<br><br>I'm not sure what the input needs to be but to get a list of phone IPs in CM from CLI it might look more like:<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>admin:show risdb query phone<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>/Wes<br><br><br><br>On Tuesday, April 13, 2010 1:39:38 PM, Frank Arrasmith <a href="mailto:frank.arrasmith@gmail.com"><frank.arrasmith@gmail.com></a> wrote:<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>HI Vince, <br> This is the first time i've seen this. it looks pretty cool, but I'm not sure about one thing. On the Readme file it says you can pull the list of your IP's by running " show ephone | tftp ... " . Where are you executing this from? the Call Manager CLI? if so, do you SCP it off of the box or does it create that list in the TFTP directory where you can download? I havent got the chance to try it yet, but looking forward to it. Thanks<o:p></o:p></p><div><p class=MsoNormal>On Mon, Apr 12, 2010 at 1:49 PM, Vince Loschiavo <<a href="mailto:VLoschiavo@data-corporation.com">VLoschiavo@data-corporation.com</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'> </span><o:p></o:p></p><p>All,<o:p></o:p></p><p> <o:p></o:p></p><p>Thank you all for your help in the past with this project.<o:p></o:p></p><p> <o:p></o:p></p><p>I have recently resurrected this project and have implemented some features suggested by members of this list.<o:p></o:p></p><p> <o:p></o:p></p><p>New features:<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Improved overall speed<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Subnet scanning via SYN/ACK & TCP Socket checking<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Additional Phone support<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Script execution time<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Output file sorted by IP address<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Verbose and force overwrite options<o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Improved online help –h, --help<o:p></o:p></p><p> <o:p></o:p></p><p>It uses some Perl Modules that are not included in most standard perl distributions. Please use CPAN (or CPANPLUS) to install them: <o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>Sort::Key::IPv4 <o:p></o:p></p><p style='margin-left:.5in'><span style='font-family:Symbol'>·</span><span style='font-size:7.0pt'> </span>NetAddr::IP<o:p></o:p></p><p> <o:p></o:p></p><p>You can get the latest version from sourceforge<o:p></o:p></p><p><a href="https://sourceforge.net/projects/cipinventory/" target="_blank">https://sourceforge.net/projects/cipinventory/</a><o:p></o:p></p><p> <o:p></o:p></p><p>I have successfully tested the latest version (v0.10) on various flavors of Linux, but need Windows XP/7/2003/2008 (ActivePerl) testers. Any volunteers? Please use the sourceforge page forums for discussion/bugs/etc.<o:p></o:p></p><p> <o:p></o:p></p><p>Thanks,<o:p></o:p></p><p> <o:p></o:p></p><p>Vincent Loschiavo<o:p></o:p></p><p><a href="mailto:vloschiavo@gmail.com" target="_blank">vloschiavo@gmail.com</a> <o:p></o:p></p></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><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><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><pre><o:p> </o:p></pre><pre style='text-align:center'><o:p> </o:p></pre><pre style='text-align:center'><o:p> </o:p></pre><pre style='text-align:center'><hr size=4 width="90%" align=center></pre><pre style='text-align:center'><o:p> </o:p></pre><pre style='text-align:center'><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>cisco-voip mailing list<o:p></o:p></pre><pre><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><o:p></o:p></pre><pre><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></pre><pre> <o:p></o:p></pre><p class=MsoNormal><o:p> </o:p></p></div></body></html>