Resolved—Known Issue with Response Group Service CDR Queries
Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.
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 https://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.
Before and After Examples
List of calls received by the Response Group Service
Figure 1 shows the details of all of the calls that have been received by the Response Group Service. Figure 2 shows an example of the report that now correctly lists all calls that were received, including those that were received via a Mediation Server.
Figure 1. Before: List of calls received by the Response Group Service
.jpg "Before: List of calls received")
Figure 2. After: List of Calls received by the Response Group Service
.jpg "After: List of Calls received")
Total number of calls received by the Response Group Service
Figure 3 shows you a summary of all of the calls that have been received by the Response Group Service. Figure 4 shows an example of the report that now correctly lists all calls that were received, including those that were received via a Mediation Server. This updated report also shows some optimizing in how the summary data is presented.
Figure 3. Before: Total number of calls received by the Response Group Service
.jpg "Before: Total number of calls received")
Figure 4. After: Total number of calls received by the Response Group Service
.jpg "After: Total number of calls received")
List of calls successfully accepted by agents in the Response Group Service
Figure 5 shows you the details of all the calls that have been accepted by agents in the Response Group Service. Figure 6 shows an example of the report that now correctly lists all calls that were accepted, including those that were received via a Mediation Server.
Figure 5. Before: List of calls successfully accepted by agents in the Response Group Service
.jpg "Before: List of calls successfully accepted")
Figure 6. After: List of calls successfully accepted by agents in the Response Group Service
.jpg "After: List of calls successfully accepted")
Total number of calls successfully accepted by agents in the Response Group Service
Figure 7 shows you a summary of all of the calls that have been accepted by agents in the Response Group Service. Figure 8 shows an example of the report that now correctly lists all calls that were accepted, including those that were received via a Mediation Server. This report also shows some optimizing in how the summary data is presented.
Figure 7. Before: Total number of calls successfully accepted by agents in the Response Group Service
.jpg "Before: Total number of calls successful")
Figure 8. After: Total number of calls successfully accepted by agents in the Response Group Service
.jpg "After: Total number of calls successfully accepted")
List of calls successfully transferred by the Response Group Service on queue time out or queue overflow
Figure 9 shows you a list of all of the calls that have been transferred by the Response Group Service on queue time out or on queue overflow. As you can see in Figure 9, the before version of this query incorrectly identified the transferred calls. Figure 10 shows an example of the report that now correctly lists only the calls that were transferred.
Figure 9. Before: List of calls successfully transferred by the Response Group Service on queue time out or queue overflow
.jpg "Before: List of calls successfully transferred")
Figure 10. After: List of calls successfully transferred by the Response Group Service on queue time out or queue overflow
.jpg "After: List of calls successfully transferred")
Total number of calls successfully transferred by the Response Group Service on queue time out or queue overflow
Figure 11 shows you a summary of all of the calls that have been transferred by the Response Group service on queue time out or on queue overflow. As you can see in Figure 11, the before version of this query incorrectly identified the transferred calls. Figure 12 shows an example of the report that now correctly lists only the calls that were transferred.
Figure 11. Before: Total number of calls successfully transferred by the Response Group Service on queue time out or queue overflow
.jpg "Before: Total number of calls successful")
Figure 12. After: Total number of calls successfully transferred by the Response Group Service on queue time out or queue overflow
.jpg "After: Total number of calls successful")
Please keep in mind that this updated SQL query is provided ‘as-is’ similar to the entire Resource Kit application itself.
* Special thanks to Stéphane Cavin, Kangmo Kim, and Sam Gao for providing the updated xml file and for reviewing my write up of the issue.
Additional Information
To learn more, check out the following articles:
Download the .xml file that is a companion to this article at https://go.microsoft.com/fwlink/?LinkId=183643
Office Communications Server 2007 R2 Resource Kit Tools at https://go.microsoft.com/fwlink/?LinkId=158267
Response Group Service Support at https://go.microsoft.com/fwlink/?LinkId=183648
Communications Server Resources
Visit the Communications Server main page at https://go.microsoft.com/fwlink/?LinkId=132607.
View the complete Communications Server documentation library at https://go.microsoft.com/fwlink/?LinkId=132106.
Download the Communications Server content as Word documents at https://go.microsoft.com/fwlink/?LinkId=133609.
Download the Communications Server documentation as a compiled help file at https://go.microsoft.com/fwlink/?LinkId=160355. (Scroll down to the Additional Information section and download OCSDocumentation.chm.)
Read weekly articles for Communications Server IT professionals on NextHop at https://go.microsoft.com/fwlink/?LinkId=181907.
Read weekly articles for Communications Server developers on UCode at https://go.microsoft.com/fwlink/?LinkId=177892.
Follow tweets from the Communications Server team at https://go.microsoft.com/fwlink/?LinkId=167909.
We Want to Hear from You
To give us feedback about this article or to propose a topic for an article, e-mail us at NextHop@microsoft.com.
You can also send us a tweet at https://www.twitter.com/DrRez.