Forced Authorization Code Reports

[thibaultct]

Hi! I'm using Callmanager 4.2. Is there a way to send automatically by email a monthly report of the Forced Authorization Codes?

[smalkeric]

From Publisher, You can go to Start -> Programs -> Microsoft SQL Server -> Query Analyzer and login using Windows Authentication. In the toolbar menu,make sure that you select the currect database which is CCMXXXX, and in the

query window type:"select description, code, authorizationlevel from FACInfo" and now execute the query by clicking on the green arrow button in toolbar menu. You can copy the information into excel or notepad and save it.

[thibaultct]

Maybe I didn't explained myself clearly. What I want is the "Call Details by Authorization Level" report from the CDR Analysis and reporting website to be sent automatically each 1rst day of the month.