Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
LCSLog.Messages Table Empty

Locked LCSLog.Messages Table Empty

  • Tuesday, October 13, 2009 5:18 PM
     
     
    Sign In to Vote
    0
    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.
       

    All Replies

    • Tuesday, October 13, 2009 6:45 PM
       
       Proposed
      Sign In to Vote
      0
      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
      • Proposed As Answer by Sri Todi Wednesday, October 14, 2009 1:39 AM
      •  
         
      • Tuesday, October 13, 2009 8:18 PM
         
         
        Sign In to Vote
        0
        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 10:38 PM
          Moderator
           
           
          Sign In to Vote
          0
          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
             
          • Wednesday, October 14, 2009 3:18 PM
             
             
            Sign In to Vote
            0
            The archivingcdrreporter is not returning results for response group calls. has anyone seen this? Thanks.
               
            • Tuesday, October 20, 2009 3:27 AM
              Moderator
               
               
              Sign In to Vote
              0
              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!