<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 12 (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:Verdana;
        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;}
 /* 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.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
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.content
        {mso-style-name:content;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2050" />
</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=Section1>

<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'>Thanks
for the heads up on the &#8220;</span><span style='font-family:"Calibri","sans-serif";
color:windowtext'>show risdb query phone&#8221;.<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:windowtext'><o:p>&nbsp;</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>&nbsp;</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>&nbsp;</o:p></span></p>

<div>

<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Arial","sans-serif";
color:black'>Vincent Loschiavo</span></b><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:black'><br>
</span><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";
color:#7F7F7F'>Director of Consulting Services</span></b><b><span
style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#7F7F7F'><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,&nbsp; 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@01CADBAE.E5C759C0" 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@01CADBAE.E5C759C0" 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>&nbsp;</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>&nbsp;</o:p></p>

<p class=MsoNormal>'ephone' is a CME entity.&nbsp; 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:<br>
<br>
<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>/Wes<br>
<br>
<br>
<br>
On Tuesday, April 13, 2010 1:39:38 PM, Frank Arrasmith <a
href="mailto:frank.arrasmith@gmail.com">&lt;frank.arrasmith@gmail.com&gt;</a>
wrote:<br>
<br>
<o:p></o:p></p>

<p class=MsoNormal style='margin-bottom:12.0pt'>HI Vince, <br>
&nbsp;&nbsp; This is the first time i've seen this.&nbsp; it looks pretty cool,
but I'm not sure about one thing.&nbsp; On the Readme file it says you can pull
the list of your IP's by running &quot; show ephone | tftp ... &quot; . Where
are you executing this from?&nbsp; 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?&nbsp; I havent got the chance to try it yet, but looking forward to
it.&nbsp; Thanks<o:p></o:p></p>

<div>

<p class=MsoNormal>On Mon, Apr 12, 2010 at 1:49 PM, Vince Loschiavo &lt;<a
href="mailto:VLoschiavo@data-corporation.com">VLoschiavo@data-corporation.com</a>&gt;
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'>&nbsp;</span><o:p></o:p></p>

<p>All,<o:p></o:p></p>

<p>&nbsp;<o:p></o:p></p>

<p>Thank you all for your help in the past with this project.<o:p></o:p></p>

<p>&nbsp;<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>&nbsp;<o:p></o:p></p>

<p>New features:<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Improved
overall speed<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Subnet
scanning via SYN/ACK &amp; TCP Socket checking<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Additional
Phone support<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Script
execution time<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Output
file sorted by IP address<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Verbose
and force overwrite options<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Improved
online help &#8211;h, --help<o:p></o:p></p>

<p>&nbsp;<o:p></o:p></p>

<p>It uses some Perl Modules that are not included in most standard perl
distributions.&nbsp; Please use CPAN (or CPANPLUS) to install them: <o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Sort::Key::IPv4
<o:p></o:p></p>

<p style='margin-left:.5in'><span style='font-family:Symbol'>&middot;</span><span
style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>NetAddr::IP<o:p></o:p></p>

<p>&nbsp;<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>&nbsp;<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.&nbsp; Any
volunteers?&nbsp; Please use the sourceforge page forums for
discussion/bugs/etc.<o:p></o:p></p>

<p>&nbsp;<o:p></o:p></p>

<p>Thanks,<o:p></o:p></p>

<p>&nbsp;<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><br>
<br>
<o:p></o:p></p>

<pre><o:p>&nbsp;</o:p></pre><pre style='text-align:center'>

<hr size=4 width="90%" align=center>

</pre><pre><o:p>&nbsp;</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>&nbsp; <o:p></o:p></pre>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>