First, install an OCS 2007 R2 monitoring server, on a seperate server from the OCS pool. Once that is setup using the MS directions in the link at the beginning of this post. Create a new SQL View on the LcsCDR database with the following code below. USE [LcsCDR] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER … Continue reading