This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SFB 2015 - SQL database seek - get users phone numbers

Question
0

Sign in to vote

SFB 2015 STD edition.

Opened SQL management studio and connected to RTCLOCAL instance.

We need to find a phone number of a particular user.

Running this command does not return any results:

SELECT TOP 1000 [ResourceId] ,[UserAtHost] FROM [rtc].[dbo].[Resource] WHERE UserAtHost LIKE 'jasmine@%'

We have followed this tutorials:

http://masteringlync.com/2014/05/19/looking-up-published-telephone-numbers-in-the-database/

http://www.b-blog.info/en/how-to-find-users-published-phone-numbers-in-lync-2013-database.html

But as it looks like this SELECT statement only works for LYNC2013 and we have SFB2015.

Are there changes in database between lync2013 and SFB2015 and that data is in different table?

Please help, with best regards.

p.s. - we have two std sfb2015 with pool resiliency enabled, if that counts anything?

bostjanc

Sunday, June 5, 2016 6:05 PM

All replies

0

Sign in to vote
What error do you get?

Any reason why you don't use SFB powershell instead?

Get-CsUser -Filter {LineUri -like "tel:+15555555"}

or

Get-Csuser user@domain.com | Select-Object LineUri

Please mark as helpful if you find my contribution useful or as an answer if it does answer your question. That will encourage me - and others - to take time out to help you. Thank you! Off2work
- Proposed as answer by Eason Huang Tuesday, June 7, 2016 3:02 AM
- Unproposed as answer by B_C_R Wednesday, June 8, 2016 7:39 AM
Sunday, June 5, 2016 6:31 PM
0

Sign in to vote

Tried with: "Get-CsUser -Identity "sip:address" | fl "

User has double phone numbers in his contact card.

He did not manually put another phone number on client side, neither that data exists in Active Directory, so that's why would like to see in SQL object....

bostjanc

Wednesday, June 8, 2016 7:40 AM
0

Sign in to vote

Hi,

Have you checked if this comes from Sharepoint, because SfB get information from several location, AD, Exchange, Sharepoint?
"Certified" OCS specialist

Thursday, September 13, 2018 4:23 AM
0

Sign in to vote

Use ldp.exe to perform a search against (lineURI=+the duplicate number).

Thursday, September 13, 2018 9:10 AM