<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1250"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Mordechai,<br>
<br>
In CM5.x the DRS backup process actually exports to .csv files so you
could grab the .tar file from backup destination and extract the data.<br>
<br>
otherwise the only way is going to be axl. direct queries should not
be too bad, just don't go for complex joins or data modification.<br>
<br>
/Wes<br>
<br>
Mordechai wrote:
<blockquote cite="mid:001501c8b615$830e73b0$0b00a8c0@t41" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (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:Tahoma;
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";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{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";
color:black;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
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"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">No, not CDRs
(which are covered nicely by
hourly exports via sftp to a windows server and from there imported to
my
off-line MS-SQL for queries etc).<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">We have over
10000 users and I am often
asked to generate reports so they can plan MAC and rollout activities.
I haven’t
tried an AXL query that would result in a more that a couple of
hundreds
records, that’s why I am asking what to anticipate if I want to dump
the
entire endusers table for example.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Of course,
all activities that might
impact performance are done off-hours (after being tested in the lab). <o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Regards,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Mord<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font
color="black" face="Times New Roman" size="3"><span
style="font-size: 12pt; color: windowtext;">
<hr tabindex="-1" align="center" size="2" width="100%"></span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;"> Wes
Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, May
14, 2008 5:59
PM<br>
<b><span style="font-weight: bold;">To:</span></b> Mordechai<br>
<b><span style="font-weight: bold;">Cc:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re:
[cisco-voip] redirect
admin:run sql to a file</span></font><font color="black"><span
style="color: windowtext;"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">Hi Mord,<br>
<br>
What are you querying that is going to generate 20K records? My only
guess
would be CDR data. If so, doing it from CLI or AXL will have the same
result. Informix has not been a strong point of the 5.x/6.x platform
so I
would also be very concerned about performance impact. 20k records
would
very much be an off hours activity.<br>
<br>
If you are looking to retrive CDR data then have a look at the CAR
interface. It includes an item to export CDR's. Very conventient
for a post mortem analysis.<br>
<br>
Regards,<br>
Wes<br>
<br>
<br>
Mordechai wrote: <o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Wes,
thanks for the VERY quick response. In your experience,
would there be an impact if the response generates over 20K records? I
am
reluctant to experiment in production and the lab has only a few dozen
users/phones.<u5:p></u5:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><u5:p> </u5:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Regards,<u5:p></u5:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Mord<u5:p></u5:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><u5:p> </u5:p></span></font><o:p></o:p></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font
color="black" face="Times New Roman" size="3"><span
style="font-size: 12pt; color: windowtext;">
<hr tabindex="-1" align="center" size="2" width="100%"></span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;"> Wes
Sisk [<a moz-do-not-send="true" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
<br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, May
14, 2008 3:30
PM<br>
<b><span style="font-weight: bold;">To:</span></b> Mordechai<br>
<b><span style="font-weight: bold;">Cc:</span></b> <a
moz-do-not-send="true" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re:
[cisco-voip] redirect
admin:run sql to a file</span></font><o:p></o:p></p>
</div>
<u5:p></u5:p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><u5:p> </u5:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">AXL is preferred interface for
any type of systemic
updates. CLI is for troubleshooting purposes only. The CLI is also
subject to change at any time without notice or warning. Whereas AXL
is
at least tested for backward compatibility.<br>
<br>
Regards,<br>
Wes<br>
<br>
Mordechai wrote: <u5:p></u5:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hello,<u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Anyone knows how (if) to
redirect run sql command
output to a file instead of screen? <u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">I can use AXL but am not
sure how it is going to
handle large volume response. <u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Thanks in advance,<u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Mord,<u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">NetVision Expert
Solutions Inc.<u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><a
href="mailto:m.rabinovich@nves.ca" moz-do-not-send="true">m.rabinovich@nves.ca</a><u1:p></u1:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><u1:p> </u1:p><u5:p></u5:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><u5:p> </u5:p><o:p></o:p></span></font></p>
<p><font color="black" face="Times New Roman" size="2"><span
style="font-size: 10pt;">No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008
7:49 AM</span></font><u5:p></u5:p><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><u5:p> </u5:p><o:p></o:p></span></font></p>
<p><font color="black" face="Times New Roman" size="2"><span
style="font-size: 10pt;">No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008
7:49 AM</span></font><u5:p></u5:p><o:p></o:p></p>
<pre wrap=""><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><u5:p> </u5:p><o:p></o:p></span></font></pre>
<pre style="text-align: center;"><font color="black"
face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre style="text-align: center;"><font color="black"
face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre style="text-align: center;"><font color="black"
face="Courier New" size="2"><span style="font-size: 10pt;">
<hr align="center" size="4" width="90%">
</span></font></pre>
<pre style="text-align: center;"><font color="black"
face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre style="text-align: center;"><font color="black"
face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><u5:p> </u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">_______________________________________________<u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">cisco-voip mailing list<u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><a href="mailto:cisco-voip@puck.nether.net"
moz-do-not-send="true">cisco-voip@puck.nether.net</a><u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><a
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
moz-do-not-send="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u5:p></u5:p><o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <u5:p></u5:p><o:p></o:p></span></font></pre>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p><font color="black" face="Times New Roman" size="2"><span
style="font-size: 10pt;">No
virus found in this incoming message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008
7:49 AM</span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p><font color="black" face="Times New Roman" size="2"><span
style="font-size: 10pt;">No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008
7:49 AM</span></font><o:p></o:p></p>
</div>
<br>
<p><font size="2">No virus found in this incoming message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008 7:49 AM<br>
</font> </p>
<br>
<p><font size="2">No virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:
5/14/2008 7:49 AM<br>
</font> </p>
</blockquote>
</body>
</html>