Missing archiving tables
-
Tuesday, September 22, 2009 2:22 PM
Hey everyone,
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!
All Replies
-
Tuesday, September 22, 2009 10:32 PMHave a look at this Powershell script by the OCS Team to retreive Archived messages from OCS
http://communicationsserverteam.com/archive/2008/01/14/69.aspx
- Belgian Unified Communications Community : http://www.pro-exchange.be - -
Monday, September 28, 2009 10:02 AMModeratorhi
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:
http://www.microsoft.com/downloads/details.aspx?familyid=959cb709-d81e-4dde-821f-0411dfcfc073&displaylang=en
Regards! -
Tuesday, October 06, 2009 10:17 AMModeratorhi
Any update for your issue?
Have you found the right way?
Regards!