#lync2010

So the reason why we needed to do this was cause a user changed from an old number to a new number and for some reason it kept reverting back to her old number. We checked AD and Lync admin and both were set to her new number. The only place that it was coming up with her old number was her lync contact card. 

Here is the fix that I used to removed it, but try at your own risk.

The dbimpexp tool can be found in the support directory of Lync:

X:\Program Files\Common Files\Microsoft Lync Server 2010\Support

To change the information we will first need to export the information from the database:

dbimpexp /hrxmlfile:”c:\export.xml” /sqlserver:"[lyncsqlserver]\rtc" /restype:user /user:[email protected]

If you want to remove or change an entry you will need to update all entries in the XML. When you have replaced each entry save the file and import it into the database:

dbimpexp /import /hrxmlfile:”c:\export.xml” /sqlserver:"[lyncsqlserver]\rtc" /restype:user /user:[email protected]

When the data is uploaded in the database a new addressbook needs to be generated. This to update the addressbook with the new information.

1. In DHCP right click on server and goto define vendor classes.

2. Add a new class with below details

Display Name MSCPEClient Description UC Vendor Class Id ACSII Data CPE-OCPHONE

3. Set predefined options and select the new class.

4. Add new option type with below details.

Name VLANID Data Type Word Code 10 Description VLAN Identifier

5. Add to server scope and enter value for the voice vlan in the new DHCP option. This will automatically change to hexa-decimal.

New-CsCommonAreaPhone -LineUri "tel:<phone#>" -RegistrarPool "<lync pool" -OU "OU=Phones,DC=<domain>,DC=net" -Description "Common Phone" -DisplayName "Common Phone" -DisplayNumber "<Phone#>"

Set-CsClientPin –Identity “Common Phone” -Pin 112233

Get-CsCommonAreaPhone -Identity "Common Phone" | set-cscommonareaphone -identity "Common Phone"

1. Using the Microsoft SQL Management Studio tools connect LyncServerName\RTC using an account that has full CSAdministrator rights.

2. When connected, under databases right click "RTC" and select "New Query".

3. In the new query entry fieldtype the following:

DECLARE @RC int DECLARE @_Owner nvarchar(4000) EXECUTE @RC = [rtc].[dbo].[ImpDeleteContactGroups2] "[email protected]" GO