Persistent Chat database schema
This documents the schema of the Persistent Chat database in Skype for Business Server.
The Persistent Chat database refers to the database corresponding to the Skype for Business Server Back End Server roles PersistentChatStore (corresponding to the mgc database) and PersistentChatComplianceStore (corresponding to the mgccomp database). The goal of publishing this schema is to enable you to build queries and gain some insights into building useful reporting around chat usage, active rooms, top posters, and so on.
We reserve the right to evolve this schema. Microsoft does not make any guarantees to maintain full backward compatibility with this published schema.
Follow these best practices:
No SELECT* // is supported because the column list can grow.
No user-generated schema modifications are supported.
No write operations are supported.
Test any queries that you build on representatively-sized databases to be sure that the queries can perform at a level to meet your needs.