TechContrarian

The Archiving Report* is meant to provide an easy way to pull information out of the archiving database.  It builds on the functionality provided by the Archiving PowerShell script that was written (http://communicationsserverteam.com/archive/2009/09/28/584.aspx) and adds a GUI interface, the ability to filter by date, and message formatting.  It has been tested against OCS 2007 R2 and SRS 2005.

 
Installation
1.       Open Report Manager – http(s)://<SRS Server>/Reports
2.       Click on New Folder
3.       Give the folder a name – i.e. OCSArchivingReport
4.       Click OK
5.       Click on the folder you just created
6.       Click on Upload File
7.       Browse to the location where you downloaded OCSArchivingReport.rdl and select the file
8.       Click OK to upload the report
9.       Click on New Data Source
10.   Enter LcsLog for the Data Source name
11.   Enter Data Source=<SQL Servername>;Initial Catalog=LcsLog for the Connection String
a.       Replace <SQL Servername> with your SQL server\instance
12.   Select the Windows integrated security radio button
13.   Click OK
14.   Click on OCSArchivingReport
a.       You will see [...]