locked
LCSLog.Messages Table Empty RRS feed

  • Question

  • Hello. I am attempting to archive im conversations but the messages table is empty. I followed the docs to config the archiving role. I am seeing activity w/ sql profiler on the sql 2005 sp3 server. I am seeing data in other tables (users, pools, sessionDetails, etc.) but not in the messages table. Here is the output from the sql profiler:

    exec dbo.LogMessage N'EMAIL REMOVED',N'',0,0,N'EMAIL REMOVED',N'',0,0,N'',0x66376664313933323136616534643738383462616362323733663738336262633B663239316663323032373B32393237316663393933,N'UCCAPI/3.5.6907.37 OC/3.5.6907.37 (Microsoft Office Communicator 2007 R2)',N'UCCAPI/3.5.6907.37 OC/3.5.6907.37 (Microsoft Office Communicator 2007 R2)',N'',N'JRWIN2K8MAIL2',N'JRWIN2K8MAIL2.xxx.com',N'',32,0,1,200,-1,18,'2009-10-13 16:50:48:570','2009-10-13 16:50:48:650',0,N'',N'',N'',N'',NULL,NULL,2,1,N''

    I ran this from sql query analyzer with no errors as well. Any ideas? Thanks.
    Tuesday, October 13, 2009 5:18 PM

All replies

  • Most likely you have enabled Call Detail Records (CDR) but not IM Archiving. These are configured separately but stored in the same database.

    Ensure that 'Activate Content Archiving' is enabled, see http://technet.microsoft.com/en-us/library/bb905919.aspx
    Tuesday, October 13, 2009 6:45 PM
  • All that was set. I rebooted the machine and now i see the db entries. i wish there was a nice reporting interface. the reskit tool and the powershell script floating out there are pretty basic.
    Tuesday, October 13, 2009 8:18 PM
  • The SQL report pack is nice for Monitoring and CDR.  If you're talking about looking at the IMs themselves we have a lightweight web-based app called SmartSearch that you can use for searching the IM archive data.  It's not meant to compete with the big security suites like Facetime but is nice if you just need to search from time to time and don't need a lot of bells and whistles.  If you want more info my e-mail address is in my profile.
    Mike Stacy | Evangelyze Communications | http://www.evangelyze.net/cs/blogs/mike
    Tuesday, October 13, 2009 10:38 PM
    Moderator
  • The archivingcdrreporter is not returning results for response group calls. has anyone seen this? Thanks.
    Wednesday, October 14, 2009 3:18 PM
  • Hi
    What do you mean by "response group calls".
    In my opinion, when external user dial in, if you configure the response group service, and then the call was established, a peer-to-peer call happened.
    So, I think it is contained in the peer-to-peer CDR table or the voip CDR table.
    Other link you can refer to get more information about it.
    http://blogs.technet.com/jitreddy/archive/2008/07/31/archiving-cdr-reporter-tool-and-custom-sql-queries.aspx 
    http://technet.microsoft.com/en-us/library/bb964005.aspx

    If imisunderstand your issue, please tell me.
    Regards!
    Tuesday, October 20, 2009 3:27 AM
    Moderator