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:

• To use the tool, you will need to download the zip file 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.

Source:→ OCS Blog

Microsoft, OCS, Office, Communication, Server, Office Communication Server, PowerShell, Script, IM, Archive, Database, Archiving, Tools