<div>we are running mixed mode with it's own Sql account. they pull the CDR's nightly to another SQL server where they run the reports from there. Everything is pretty much cron'd from what I can remember.</div>
<div> </div>
<div>Scott<br><br></div>
<div class="gmail_quote">On Jan 23, 2008 9:42 AM, Mitchell Hunt <<a href="mailto:Mitchell.Hunt@ipitomi.com">Mitchell.Hunt@ipitomi.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" style="WORD-WRAP: break-word" vlink="blue" link="blue">
<div>
<div><font face="Arial"> </font> </div>
<div><font face="Arial">
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Archive the CDRs to another location periodically is another solution.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">That way they can do what they like with them.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mitch</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">
cisco-voip-bounces@puck.nether.net</a> [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>] <b><span style="FONT-WEIGHT: bold">On Behalf Of </span></b>Ryan Ratliff
<br><b><span style="FONT-WEIGHT: bold">Sent:</span></b> 23 January 2008 17:27<br><b><span style="FONT-WEIGHT: bold">To:</span></b> d4rk f1br<br><b><span style="FONT-WEIGHT: bold">Cc:</span></b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">
cisco-voip@puck.nether.net</a><br><b><span style="FONT-WEIGHT: bold">Subject:</span></b> Re: [cisco-voip] CallManager 4.1(3) Accessing CDR data for CustomReports?</span></font></p></div>
<div>
<div></div>
<div class="Wj3C7c">
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">You won't break anything by changing SQL back to mixed mode. That way you can create a SQL only user for them and not give them admin access to the entire server. It requires a bounce of the SQL server though.
</span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p style="MARGIN: 0cm 0cm 0pt"><font face="Helvetica" size="1"><span style="FONT-SIZE: 9pt; FONT-FAMILY: Helvetica">-Ryan</span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">On Jan 23, 2008, at 11:54 AM, d4rk f1br wrote:</span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Running CallManager 4.1(3) and want to setup or allow some of our sql reporting and developer folks access to the CDR database so that they can create some custom reporting for supervisors and management.
</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Not finding any best practices regarding anything related to this. I do notice that my CM cluster sql appears to be configured with "Windows only" authentication.
</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I notice there are already some users associated with the CDR database on CM.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">CCMCDR</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">CCMServiceRW</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">CCMUser</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Administrator</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Should one create a new user for this or use an existing? Should I leave CM set to use 'Windows only' authentication ? Can you even change that without having a negative impact?
</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I know that prior to 4.x the default use to be mixed mode allowing for SQL and Windows authentication.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Any thoughts or suggestions regarding any of this would be appreciated. Always like to hear from others prior to moving forward with things I am not 100% sure about.
</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">_______________________________________________</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">cisco-voip mailing list</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span></font></p>
</div></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div></div></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><br>______________________________________________________________________<br>This email has been scanned by the MessageLabs Email Security System.<br>
For more information please visit <a href="http://www.messagelabs.com/email" target="_blank">http://www.messagelabs.com/email</a> <br>______________________________________________________________________</span></font></p>
</div></font></div>
<div> </div>
<div>
<p><span style="FONT-SIZE: 7.5pt">Ipitomi is a limited company registered in England<span style="COLOR: #1f497d">. </span>Registered Office: 45 Moorfields, London EC2Y 9AE<span style="COLOR: #1f497d"> </span>Registration Number:
</span><span lang="EN-GB" style="FONT-SIZE: 7.5pt">3576505</span><span style="FONT-SIZE: 7.5pt">. VAT number 719086615<span style="COLOR: #1f497d"></span></span></p>
<p><span style="FONT-SIZE: 12pt"></span></p>
<p><span style="FONT-SIZE: 7.5pt">Please note that Ipitomi may monitor email traffic data and also the content of email for the purposes of security and staff training. </span><span style="FONT-SIZE: 7.5pt">This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
</span></p></div></div>
<div> </div><br>______________________________________________________________________<br>This email has been scanned by the MessageLabs Email Security System.<br>For more information please visit <a href="http://www.messagelabs.com/email" target="_blank">
http://www.messagelabs.com/email</a> <br>______________________________________________________________________<br></div><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><br><br></blockquote></div><br>