Unified Contacts Store (UCS) Deep Dive

I decided to make a bit of a deep dive inside the UCS (Unified Contact Store) in Lync/Skype for Business.

There are two options to store your contacts – in the Lync/SfB SQL store or in the Exchange mailbox.

For me the SQL store is the less problematic one, migrating users between different pools and Office 365 is less likely to cause a problems.

Option 1: Store in Lync/SfB SQL

SELECT UserAtHost, UpdateTime, InsertTime, ExUmEnabled, UcsMode, UcsMigrationAttemptCount, LastUcsMigrationAttempt FROM [rtc].[dbo].[Resource] as r
    INNER JOIN [rtc].[dbo].[ResourceDirectory] as d on (d.ResourceId = r.ResourceId)
    INNER JOIN [rtc].[dbo].[PresenceHomedResource] as h on (h.ResourceId = d.ResourceId)
--- Optional where clause to check specific users
--- WHERE r.UserAtHost IN ( 'user@domain.com', 'user2@domain.com' )

Option 2: Unified Contact Store in Exchange

MrMAPI.exe -ChildFolders -Folder "IPM_SUBTREE\Contacts"

MrMAPI.exe -Folder "IPM_SUBTREE\Contacts\{A9E2BC46-B3A0-4243-B315-60D991004455}"

Add a Comment

Your email address will not be published. Required fields are marked *