<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">setup an ODBC connection on the other system pointing to CM.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>keep in mind that any 'reporting' they try to do, including SQL queries is directly competing with CPU time on the callmanager box that provides dialtone to your end users. small queries are ok, but if they start doing multi table joins, string manipulations, and inefficient queries then you will have no dialtone.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>/Wes</DIV><DIV><BR><DIV><DIV>On Apr 21, 2006, at 9:56 AM, Vincent De Keyzer wrote:</DIV><BR class="Apple-interchange-newline"> <DIV class="Section1"><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN style="font-size:10.0pt; font-family:Tahoma">Hello,<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN style="font-size:10.0pt; font-family:Tahoma"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma">I know how to extract CDRs into a .csv file (with Call Manager Serviceability – CDR Analysis & reporting).<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma">Now our IT guys want to automate some reporting and access the CDR DBs directly from another system.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma">What are the options?<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma">Vincent<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" face="Tahoma"><SPAN lang="EN-GB" style="font-size: 10.0pt;font-family:Tahoma"><O:P> </O:P></SPAN></FONT></P> </DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A></DIV> </DIV><BR></DIV></BODY></HTML>