locked
lync group chat conversation location RRS feed

  • Question

  • I am using Lync group chat 2010.  I need to know where the IM conversations are going.  When you dubble click on someone and take to that directly not though the chat room.  where do the conversations historys get saved.

    In the Lync IM piece the IM chats are in outlook but not in the group chat.

    I know that if you are in the chat room part the conversation stays there.  What I am looking for is when you are taking with someone on the chat room not everyone.

    Can someone help me?

    Wednesday, February 29, 2012 8:32 PM

Answers

  • Hi,

    Group Chat History is stored in SQL database,when you log in the chat room you can view the recent chat history  (messages from previous sessions still shown in the message area on logged chat rooms) and searchable history (messages no longer shown on logged chat rooms, but still available to search).In fact,at a granular level you can view the chat content in the dbo.tblChat table of the Group Chat database on the SQL server,so maybe you can remove propryatary data from this database.

    Found this information on

    http://social.technet.microsoft.com/Forums/en-US/ocsmonitoring/thread/15851ede-fa36-4ff4-bb17-809c3b6c2615

    Hope above helps


    If answer is helpful, please hit the green arrow on the left, or mark as answer. Salahuddin | Blogs:http://salahuddinkhatri.wordpress.com | MCITP Microsoft Lync

    • Proposed as answer by Sean_Xiao Monday, March 5, 2012 9:42 AM
    • Marked as answer by Sean_Xiao Tuesday, March 6, 2012 9:11 AM
    Wednesday, February 29, 2012 9:05 PM
  • Hi,

    You can have try to use SQL query to get the special message from the SQL server.

    Select * from talChat where contect like %computer% --Search the contect of group chat include the word "computer"

    or

    Select * from talChat where chatDate="2010-11-01" and userId=3 --use userId and date to search the result


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Sean_Xiao Tuesday, March 6, 2012 9:11 AM
    Monday, March 5, 2012 6:20 AM

All replies

  • Hi,

    Group Chat History is stored in SQL database,when you log in the chat room you can view the recent chat history  (messages from previous sessions still shown in the message area on logged chat rooms) and searchable history (messages no longer shown on logged chat rooms, but still available to search).In fact,at a granular level you can view the chat content in the dbo.tblChat table of the Group Chat database on the SQL server,so maybe you can remove propryatary data from this database.

    Found this information on

    http://social.technet.microsoft.com/Forums/en-US/ocsmonitoring/thread/15851ede-fa36-4ff4-bb17-809c3b6c2615

    Hope above helps


    If answer is helpful, please hit the green arrow on the left, or mark as answer. Salahuddin | Blogs:http://salahuddinkhatri.wordpress.com | MCITP Microsoft Lync

    • Proposed as answer by Sean_Xiao Monday, March 5, 2012 9:42 AM
    • Marked as answer by Sean_Xiao Tuesday, March 6, 2012 9:11 AM
    Wednesday, February 29, 2012 9:05 PM
  • what is the code to lookup everthing from today?
    Wednesday, February 29, 2012 9:33 PM
  • Hi,

    You can have try to use SQL query to get the special message from the SQL server.

    Select * from talChat where contect like %computer% --Search the contect of group chat include the word "computer"

    or

    Select * from talChat where chatDate="2010-11-01" and userId=3 --use userId and date to search the result


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Sean_Xiao Tuesday, March 6, 2012 9:11 AM
    Monday, March 5, 2012 6:20 AM