Persistent Chat database schema

Skype for Business Server 2015

This documents the schema of the сохраняемый сеанс беседы database in Skype для бизнеса Server.

The сохраняемый сеанс беседы database refers to the database corresponding to the Skype для бизнеса 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.