[cisco-voip] CallManager 4.1(3) Accessing CDR data for CustomReports?

[Scott Voll]

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.

Scott

On Jan 23, 2008 9:42 AM, Mitchell Hunt <Mitchell.Hunt at ipitomi.com> wrote:

>
>
> Archive the CDRs to another location periodically is another solution.
>
> That way they can do what they like with them.
>
>
>
> Mitch
>
>
>  ------------------------------
>
> *From:* cisco-voip-bounces at puck.nether.net [mailto:
> cisco-voip-bounces at puck.nether.net] *On Behalf Of *Ryan Ratliff
> *Sent:* 23 January 2008 17:27
> *To:* d4rk f1br
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] CallManager 4.1(3) Accessing CDR data for
> CustomReports?
>
>
>
> 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.
>
>
>
> -Ryan
>
>
>
> On Jan 23, 2008, at 11:54 AM, d4rk f1br wrote:
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> I notice there are already some users associated with the CDR database on
> CM.
>
>
>
> CCMCDR
>
> CCMServiceRW
>
> CCMUser
>
> Administrator
>
>
>
> 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?
>
>
>
> I know that prior to 4.x the default use to be mixed mode allowing for SQL
> and Windows authentication.
>
>
>
> 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.
>
>
>
>
>
> _______________________________________________
>
> cisco-voip mailing list
>
> cisco-voip at puck.nether.net
>
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
>
> Ipitomi is a limited company registered in England. Registered Office: 45
> Moorfields, London EC2Y 9AE Registration Number: 3576505. VAT number
> 719086615
>
> Please note that Ipitomi may monitor email traffic data and also the
> content of email for the purposes of security and staff training. 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.
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080123/12a07fc9/attachment.html