One of our customers asked me about view content of IM with OCS. Can this be done or do we need 3rd party. The good thing is we don’t need a 3rd party tool but it is an administrator toolset. I’m hoping for more of a RBAC method in the future (my wishlist!!). After deploying the OCS Archiving roll you can use the reskit to retrieve 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) Server.
There are sample scripts in the Reskit. Also our product team has written some scripts for download that provide an extract of all IM for a defined user or all IM between two users. http://communicationsserverteam.com/archive/2008/01/14/69.aspx