[cisco-voip] Remote access to the CDR SQL Database

[Ruben Montes (EU)]

Hi,
 
I want to access the CDR sql database with an ODBC connector to retrieve the data the billing department needs. I'm using CCM 4.1(3), so the authentication method for SQL is Windows mode (the sa user is disabled). As Cisco recommends, my CallManager is not in the domain, it is in its own workgroup. What should I do to access to the database? Should I use the local CCM windows account or what? Is there any possibility to do some sort of scheduled job from the SQL enteprise manager to export some data (columns)  to a remote machine out of hours, for example?
What method do you use to export from CallManager the info the billing department needs?
 
Thanks in advance,
 
Ruben
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060810/ad17d1fe/attachment.html