Export (0) Print
Expand All

List of Persistent Chat Server tables in Lync Server 2013

 

Topic Last Modified: 2012-10-06

The Persistent Chat database schema consists of the following tables.

 

Table Description

tblADCookie in Lync Server 2013

Contains the current Lightweight Directory Access Protocol (LDAP) Sync cookies. Each row corresponds to an Active Directory Domain Services domain that Persistent Chat Server is actively monitoring for changes. (Only the Active Directory domains that are relevant for Persistent Chat Server are represented in this table.)

tblPrincipalMemberDifference in Lync Server 2013

Contains group membership changes (both added and removed members) that have not yet been processed by the later Active Directory Sync steps and is one of the temporary tables (along with tblADUpdates table) that is used in the first step of Active Directory Sync.

Membership changes are stored, processed, or both, only for groups that are listed in the tblPrincipal table or that already have members listed there.

tblADUpdates in Lync Server 2013

Contains changes to Active Directory Domain Services that have not yet been processed by the later Active Directory Sync steps and is one of the temporary tables (along with the tblPrincipalMemberDifference table) that is used in the first step of Active Directory Sync.

Changes to Active Directory are stored, processed, or both only for principals that are already listed in the tblPrincipal table.

tblPrincipalMembers in Lync Server 2013

Contains principal memberships.

tblPrincipalMeta in Lync Server 2013

Contains the principals that have to be refreshed from Active Directory.

tblSkippedAffiliations in Lync Server 2013

Contains affiliations that could not be refreshed for some reason, usually due to Active Directory access errors.

This table is for informational purposes only. Its content is not used.

The principals with affiliations that could not be refreshed properly are kept in the tblPrincipalMeta table and are given another chance to be refreshed.

 

Table Description

tblPrincipalType in Lync Server 2013

Contains principal types to categorize what is in the tblPrincipal table. This table is static. It is set up during database creation and does not change.

tblPrincipal in Lync Server 2013

Contains all principals (users, folders, groups, and so on). Persistent Chat Server handles this as a flat heterogeneous list. Various columns are based on the type of each principal.

Most of these principals are cached copies of objects stored in Active Directory. Creating the cached copy in the Principal table of these Active Directory objects is referred as provisioning.

Some principals are created more aggressively than others, and some Active Directory objects are ignored altogether.

tblPrincipalAffiliations in Lync Server 2013

Contains principal affiliations that describe memberships in Active Directory security groups, Active Directory containers, and so on.

tblNode in Lync Server 2013

Contains the category node, as managed in Lync Server Control Panel.

tblRoleType in Lync Server 2013

Contains role types and their associated permission sets. This lookup table is static.

tblScopePrincipal in Lync Server 2013

Contains scopes assigned to nodes.

tblPrincipalRole in Lync Server 2013

Contains roles assigned to nodes.

tblSiopWhiteList in Lync Server 2013

Contains the registered Add-ins that can be associated with nodes.

tblEnumAttribute in Lync Server 2013

Contains only the hardcoded "Visibility" and "Behavior" attributes that are used in the tblNode table.

tblEnumValue in Lync Server 2013

Contains the values of the hardcoded "Visibility” and “Behavior" attributes that are used in the tblNode table.

 

Table Description

tblPrincipalInvites in Lync Server 2013

Contains invites for all provisioned users in the system for all nodes with Auto Invite enabled.

tblChat in Lync Server 2013

Contains all chat messages.

tblLastInviteId in Lync Server 2013

Contains the last invite ID that was generated (and used in the tblPrincipalInvites table) for each user.

tblLastChatId in Lync Server 2013

Contains the last chat ID that was generated (and used in the tblChat table) for each user.

tblPreference in Lync Server 2013

Contains user client preferences (used by legacy clients only).

tblFileToken in Lync Server 2013

Contains temporary tokens for file transfer purposes. Each time a file is uploaded or downloaded, the Persistent Chat service generates a token that the client uses to access the Web service file store.

 

Table Description

tblServerIdentity in Lync Server 2013

Contains the active servers in the Persistent Chat Server pool.

tblAdminLock in Lync Server 2013

Contains the administrator lock to run some administrator commands. The system revision entry in the tblSystemRevision table is incremented after each release of the lock.

tblSystemRevision in Lync Server 2013

Contains the revision number entry used (along with the tblAdminLock table) for achieving consistency across multiple servers.

tblActivePeers in Lync Server 2013

Contains current peer-to-peer connections between Persistent Chat services.

tblConfig in Lync Server 2013

Contains the Persistent Chat Server unsupported configuration.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft