Persistent Chat database schema in Lync Server 2013
Topic Last Modified: 2012-09-18
This documents the schema of the Persistent Chat database in Lync Server 2013 communications software.
The Persistent Chat database refers to the database corresponding to the Lync Server 2013 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.