tblPreference

tblPreference contains the users' client preferences. This is generally used by clients previous to Lync 2013.

Columns

Column Type Description
prefLabel
nvarchar (255), not null
Label with a format such as: <user sip uri>
prefSeqID
int, not null
A sequential number (per label) for versioning purposes.
prefContent
nvarchar (max)
Encoded content.
lastModifiedBy
int, not null
ID of the principal that updated the preference.

Key

Column Description
<prefLabel, prefSeqID>
Primary key.