List of Persistent Chat Server compliance tables in Lync Server 2013

Topic Last Modified: 2012-10-06

The Persistent Chat compliance database schema consists of the following tables.

List of Persistent Chat Server Compliance Tables

Table	Description
tblComplianceData in Lync Server 2013	Contains the compliance events that have not yet been processed by the configured adapter. This table includes Persistent Chat-related events, such as chat messages and file downloads. (Participant events are tracked by the tblComplianceParticipant table.) (The servers that processed the events in this table are listed in the tblComplianceFanout table.)
tblComplianceFanout in Lync Server 2013	Contains the servers that processed a compliance event. This table is tightly coupled with the tblComplianceData table.
tblComplianceParticipant in Lync Server 2013	Contains current participants per chat service and per server. It is maintained based on join and part compliance events received from the Persistent Chat service.
tblComplianceState in Lync Server 2013	Contains pool-wide compliance state information.