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

[Mitchell Hunt]

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 
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080123/30d8ae63/attachment-0001.html