Microsoft Office Communications Server 2007 R2 introduced the new Response Group Service and as a result added a few new queries to the Call Detail Record (CDR) reporting tool that is included with the Microsoft Office Communications Server 2007 R2 Resource Kit Tools. This article addresses a known issue with the Response Group Service CDR queries and shows before and after examples of the queries.

Author: Scott Stubberfield

Publication date: February 2010

Product version: Office Communications Server 2007 R2

In Communications Server 2007 R2 we introduced the new Response Group Service and as a result added a few new queries to the CDR reporting tool that is included with the Microsoft Office Communications Server 2007 R2 Resource Kit Tools. This article addresses a known issue with the Response Group Service CDR queries and shows before and after examples of the queries.

If a call is placed to the Response Group from a Communicator client, the call is listed correctly in the report. However, if the call is placed from a PSTN endpoint (via Mediation Server), the call is not listed. It turns out that the issue relates to the underlying SQL query that was included with the Archiving and CDR query tool.

Download the .xml file located at http://go.microsoft.com/fwlink/?LinkId=183643, and this should resolve the issue with the underlying queries. To take advantage of these queries, replace the downloaded .xml file with the default .xml file that is included in the \\Reskit\ArchivingCDRReporter directory.

If you had the Archiving and CDR report tool open before you replaced the .xml file, exit and restart the tool. After you restart the tool and review the CDR queries for the Response Group Service reports, you will see calls that were received from a PSTN endpoint that were previously excluded from the reports.

Read the complete article in the Technical Library.

We Want to Hear From You