locked
Persistent Chat - How to find rooms that are not in use? RRS feed

  • Question

  • Hello,

    Does anyone know how to find all Persistent Chat rooms that are not in use, for example last 45 days?

    Thank you.


    Thank you. Eric.

    Saturday, February 8, 2020 1:07 AM

All replies

  • Hi KPABA,

    You can execute the following sample command to export data from a Persistent Chat database.

    Export-CsPersistentChatData -DBInstance "atl-sql-001.litwareinc.com\rtc" -FileName "C:\Logs\PersistentChatData.zip"

    The command shown in Example exports Persistent Chat data from the Persistent Chat database located on the server atl-sql-001.litwareinc.com; the exported data will be stored in the file C:\Logs\PersistentChatData.zip.

    For more detailed information about this command, please refer to this document: https://docs.microsoft.com/en-us/powershell/module/skype/export-cspersistentchatdata?view=skype-ps.

    I have tested this command in my lab. The following files are the exported data of Persistent chat database. You can find the information you want in ChatRooms.xml.

    In the ChatRooms.xml file, the parameter “updatedOn” is the date of last activity about this chat room. The parameter “addedon” is the created date of the chat room.


    Best Regards,
    Sharon Zhao


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Monday, February 10, 2020 4:03 AM
  • Hi KPABA,

    Is there any update on this case?

    Please feel free to drop us a note if there is any update.

    Have a nice day!


    Best Regards,
    Sharon Zhao


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Monday, February 17, 2020 2:02 AM
  • Hi KPABA,

    I don't hear from you for a long time. If you have any update on this thread, please feel free to drop us a note.

    Meanwhile, if there is no issue, please remember to mark helpful reply as answer to close the thread. Your action would be helpful to other users who encounter the same issue and read this thread.

    Thanks for your understanding.


    Best Regards,
    Sharon Zhao


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Monday, February 24, 2020 8:01 AM