I been searching through all the posts as well as the deployment guide for an answer. Around last year, I upgraded our communications server to 2007 and everything appears to be working correct, except for one thing - LOGGING.
Back when we had LCS 2005, i use to run the query "select * from messages" to ensure that messages were logging. Unfortunately, that table is missing in the database for LCS 2007.
The only tables on the archiving server are : dbo.ClientVersions, dbo.Computers, dbo.ConferneceMessageRecipientList, dbo.ConferenceMessages, dbo.Conferences, dbo.CotnentTypes, dbo.DbConfigDateTime, dbo.DbConfigInt, dbo.DbErrorMessage, dbo.Dialogs, dbo.Pools, dbo.SessionDetails, and dbo.Users
There is not table for the messages. If anybody has any information or could point me in the right direction, I would really appreciate it. Thank you!Tuesday, September 22, 2009 2:22 PM
Have a look at this Powershell script by the OCS Team to retreive Archived messages from OCS
- Belgian Unified Communications Community : http://www.pro-exchange.be -Tuesday, September 22, 2009 10:32 PM
You can learn more aobut the achieving and cdr database schema from the OCS2007 technical reference DOC.
May be it will help you.
You can download the DOC form below link:
Regards!Monday, September 28, 2009 10:02 AMModerator