<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
CM 5.x or 6.x:<br>
run sql select * from typedevice<br>
this shows the enum for each device type. Type 62 is h323 gateway.<br>
<br>
admin:run sql select name,tkmodel from device where tkmodel=62<br>
name tkmodel <br>
===== ======= <br>
1.1.1.1 62 <br>
<br>
other database details in the database dictionary online here:<br>
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html</a><br>
<br>
/Wes<br>
<br>
Keith Klevenski wrote:
<blockquote
cite="mid:B6327EA757A9E64A8A14B892712D92EC0A4F3E@houexh01.rignet.org"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Arial","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;}
@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="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal">Hope everyone is well today.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I need to export all of our gateways and
descriptions from
each from SQL, but I’m having a hard time with this. 99% of our
gateways
are H323 and I would expect to find the gateways in the H323Device
table, but I
do not see any IP addresses or descriptions in this table. Where
should I be
looking?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="color: black;">Keith Klevenski</span></b><span
style="color: black;"><br>
<b>Senior IP Telephony Engineer</b><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: gray;">RigNet Inc.<br>
1880 S. Dairy Ashford<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: gray;">Suite 300</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: gray;"><br>
</span><span style="color: gray;">Houston, TX
77077 </span><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Office: +1
281.674.0702<br>
Mobile: +1 713.677.3925</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"><a
moz-do-not-send="true" href="http://www.rig.net/"
title="http://www.rig.net/"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;">http://www.rig.net</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span style="color: gray;" lang="EN">"Always
Connected"</span></i><span style="color: black;"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</body>
</html>