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.