<DIV>Hi Klaus,</DIV>
<DIV>They are same, that was a typing mistake. Sorry for that. </DIV>
<DIV>If possible can you share the query used in SERWEB. I never used serweb, it will help me even if you provide some links to it.</DIV>
<DIV> </DIV>
<DIV>Even I think that the latest version should not have any problems in the normal usage. I thinking of deploying it in my production environment.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>jayesh</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>Klaus Darilion <klaus.mailinglists@pernau.at></I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">jayesh nambiar wrote:<BR>> hi everybody,<BR>> I've just put my openser 0.9.5 in the production environment and it <BR>> works well. For now, I jus use a query to extract the CDR <BR>> as "call_date", "orig_number", "termination_number", "duration" and <BR>> "src_ip".<BR>> but when the volume is very large I get the following problem. The <BR>> scenario is as follows.<BR>> <BR>> call_date | orig_number | <BR>> term_number | duration | src_ip<BR>> 2005-09-25 20:45:30 | 203@my_sip_server | <BR>> 56924536@my_sip_server | <BR>> 14:00:30 X.X.X.X <BR>> <BR>> 2005-09-25 20:45:30 |56924356@my_sip_server | 43234123@my_sip_server <BR>> | 4:00:30 X.X.X.X <BR>> <BR>> I get the same number as the origination number which was the <BR><BR>they are different:<BR>56924536@my_sip_server<BR>56924356@my_sip_server<BR>^^<BR><BR>are they real different
or is this a type?<BR><BR>I always used the SQL query from serweb (the accouting tab) to match CDRs.<BR><BR>regards<BR>klaus<BR><BR>> destination number some moments before, when in reality it is not <BR>> possible to call from that particular number.<BR>> But this only happens when the calling volume is really large. Does <BR>> anyone have any idea regarding this.<BR>> If you want to see the query I can do that.<BR>> pls share if there is some better query to generate the CDR..<BR>> <BR>> I have also downloaded the latest version 0.10.x from CVS head. Can <BR>> somebody tell me how stable is it for the production environment.<BR>> <BR>> thanx<BR>> jayesh<BR>> <BR>> ------------------------------------------------------------------------<BR>> Yahoo! for Good<BR>> Click here to donate <HTTP: redcross-donate3 store.yahoo.com />to the <BR>> Hurricane Katrina relief effort.<BR>> <BR>> <BR>>
------------------------------------------------------------------------<BR>> <BR>> _______________________________________________<BR>> Users mailing list<BR>> Users@openser.org<BR>> http://openser.org/cgi-bin/mailman/listinfo/users<BR><BR></BLOCKQUOTE></DIV><p>
                <hr size=1>Yahoo! for Good<br>
<a href="http://store.yahoo.com/redcross-donate3/">Click here to donate</a> to the Hurricane Katrina relief effort.