A lot of people would like a neat and easy way to extract IM conversation archive. So I have modified the attached report file that you add to the SQL reporting to get the following view

You will need to run the following on the Reporting Server


  1. Download the latest version of the OCSArchivingReport.  (The latest version is attached as a download to this post.)
  2. Open Report Manager – http(s)://<SRS Server>/Reports
  3. Click on New Folder
  4. Give the folder a name – i.e. OCSArchivingReport
  5. Click OK
  6. Click on the folder you just created
  7. Click on Upload File
  8. Browse to the location where you downloaded OCSArchivingReport.rdl and select the file
  9. Click OK to upload the report
  10. Click on New Data Source
  11. Enter LcsLog for the Data Source name
  12. Enter Data Source=<SQL Servername>;Initial Catalog=LcsLogfor the Connection String
    1. Replace <SQL Servername> with your SQL server\instance
  13. Select the Windows integrated security radio button
  14. Click OK
  15. Click on OCSArchivingReport
    1. You will see the following error: The report server cannot process this report. The data source connection information has been deleted. (rsInvalidDataSourceReference).  This is normal, since we haven’t linked the report to the data source we just created.
  16. Click on the Properties tab
  17. Click on Data Sources in the left-hand column
  18. Make sure A shared data source radio button is selected
  19. Click the Browse button
  20. Expand OCSArchivingReport and click on LcsLog
  21. Click OK
  22. Click Apply

This is just a modded version of the original report here http://blogs.technet.com/b/dodeitte/archive/2010/02/19/ocs-archiving-report-released.aspx

Big thank to my Colleague AMR Khalil for helping me out modding and testing that.

Download the Report.. Please modify the extension to remove PDF


You can also now download it from my BOX on the right side