Audit Persistent chat for Skype For Business

By Default,  all the content in the SQL,
you can export all room data by using cmdlet. But if i want to export 1 chat room (not a category)
Powershell cannot do that,

However, you can export the data in the SQL database

• Clear-CsPersistentChatRoom
  https://technet.microsoft.com/en-us/library/jj204976.aspx
  And all the chat message is in
  [mgc].[dbo].[Exp_ChatView]
  You need to fine the Room ID in NodeView first
  

  SELECT nodeDbId FROM [mgc].[dbo].[Exp_NodeView]

  
  

  select date,  prinDisplayName ,Content from Exp_ChatView, tblPrincipal where channelDbId='Room ID' and userId=prinGuid

  
  
  Then u can export to txt or excel

i also put the answer in the Technet Forum

https://social.technet.microsoft.com/Forums/en-US/30f9033b-bd62-45dc-8aa5-35ad45d9b800/retention-for-persistent-chat-history?forum=sfbfr