List of Persistent Chat Server compliance tables in Skype for Business Server

  • Article

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

List of Persistent Chat Server Compliance Tables

Table Description
tblComplianceData
Contains the compliance events that haven't 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
Contains the servers that processed a compliance event. This table is tightly coupled with the tblComplianceData table.
tblComplianceParticipant
Contains current participants per chat service and per server. It's maintained based on join and part compliance events received from the Persistent Chat service.
tblComplianceState
Contains pool-wide compliance state information.