Powershell Script for Retriving IM from Archving Database

Author: Thomas Laciano, Sasa Juratovic

Publication date: January 2008

Product version: Office Communications Server 2007 R2

September 28 2009 Update: For those looking for the most recent script for use with R2, see this post for details - http://communicationsserverteam.com/archive/2009/09/28/584.aspx
When customers deploy Office Communications Server 2007 Archiving they quickly request tools or sample queries to retrieve their data. The Office Communications Server 2007 Resource Kit includes the ArchivingCDR Reporter tool. This reporting tool has built-in SQL queries to retrieve and view information from the Archiving and Call Detail Records (CDR) Backend. The tool enables the user to view Office Communications Server 2007 usage reports based on the Archiving and CDR tables.

A member of our team worked on a sample* using PowerShell technology to gather all IMs for a given user or all IMs between two users. The result is output to console and a local im.xml file. The script will support the following message types:

  • text/plain
  • text/x-msmsgsinvite
  • text/rtf

To use the tool, you will need to download the zip file (updated to handle special characters on April 17, 2008 (Updated and tested by our Austrian peer Thomas Binder) and extract all files to one common directory and run ps1script. Please note the tool has the following dependencies:

  1. PowerShell v1
  2. NET 2.0 Framework 
  3. To make XLS to HTML transformation you would need MSXML 4.0 Service Pack 2 (Microsoft XML Core Services) MSXML.exe is currently part of the ZIP but it should be the same as  Command Line Transformation Utility (msxsl.exe) 

The first two items are mandatory; the third is nice to have as it will create an HTML page for the XML output.
July 2008 update from Thomas Binder:
Details: As recommended in one of the commentary postings, I replaced the line
Add-Content -Path $LocalPath -Value '<?xml version="1.0" encoding="UTF-16"?>'
Add-Content -Path $LocalPath -Value '<?xml version="1.0" encoding="ISO-8859-2"?>'

* This is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use (http://www.microsoft.com/info/cpyright.htm)

Attachment(s): Get-ArchivingData-July-2008.zip


Lync Server Resources

We Want to Hear from You

Comments (1)
  1. Powershell Script for Retriving IM from Archving Database
    thank you

Comments are closed.

Skip to main content