none
adding sip to contacts (bulk)

    Question

  • I currently have 40000 contacts without sip addresses within our AD.  I am trying to find the best way to insert the sip address into each contact?  I want to lookup either by smtp or alias.

    I am assuming this would be doen with Powershell but I wasnt having much luck.

    Any suggestions would be appreciated!

    Wednesday, March 28, 2012 4:07 PM

Answers

  • Actually this is how I did it....(figured it out on my own :))

    $sipimport = Import-Csv x:\Exchange\sip_addresses_for_contacts.csv

    ForEach ($Contact in $sipimport)

    {

     set-QADObject -identity $contact.Alias_Name -ObjectAttribute @{"msRTCSIP-PrimaryUserAddress"=$contact.sip}

    }

    ThaTs it...easy peasy

    • Marked as answer by robyoung1973 Monday, April 02, 2012 9:32 PM
    Monday, April 02, 2012 9:32 PM

All replies

  • Enable-CsUser will enable them for Lync and assign a SIP address based on the exact command you run.  Check out the examples at the bottom of the following page to see common AD filters you might use to find users who are not already enabled for Lync.  http://technet.microsoft.com/en-us/library/gg398711.aspx

    Mike Stacy | http://mikestacy.typepad.com

    Wednesday, March 28, 2012 9:52 PM
  • Sorry, just read that a little closer and I see you are asking about contact objects.  Do you want their SIP address to match their SMTP address?

    Mike Stacy | http://mikestacy.typepad.com


    Wednesday, March 28, 2012 9:56 PM
  • Hi,

    We also need to assign users to a Lync pool in addition to SIP URL. You can refer to the following article for bulk enable Lync users:

     

    http://blogs.technet.com/b/csps/archive/2010/12/08/excelenableusers.aspx

    http://blogs.technet.com/b/csps/archive/2010/06/10/scriptmoveusers.aspx

     

    Regards,

    Kent

    Thursday, March 29, 2012 6:20 AM
  • Just to be clear, I am not "enabling" users for Lync.  These are contacts that we currently have that do not have sip addresses.  I want to add their sip addresses into AD so that our users can use the contacts within Lync.

    TBH all I need is the powershell cmd to populate the msRTCSIP-PrimaryUserAddress of a contact using powershell. In powershell I would ideally like to lookup the smtp of the contact and then set msRTCSIP-PrimaryUserAddress from a csv file that I have using a foreach loop.  (The CSV file has their contact details along with their corresponding sip address).

    Thursday, March 29, 2012 1:18 PM
  • Check out this article:

    http://blogs.technet.com/b/heyscriptingguy/archive/2010/10/14/use-powershell-and-active-directory-cmdlets-to-update-users-in-active-directory.aspx

    You can pretty easily modify that script to read the mail attribute and populate msRTCSIP-PrimaryUserAddress attribute.  Don't forget to put sip: in front of the SIP address.


    Mike Stacy | http://mikestacy.typepad.com

    Thursday, March 29, 2012 2:30 PM
  • Actually this is how I did it....(figured it out on my own :))

    $sipimport = Import-Csv x:\Exchange\sip_addresses_for_contacts.csv

    ForEach ($Contact in $sipimport)

    {

     set-QADObject -identity $contact.Alias_Name -ObjectAttribute @{"msRTCSIP-PrimaryUserAddress"=$contact.sip}

    }

    ThaTs it...easy peasy

    • Marked as answer by robyoung1973 Monday, April 02, 2012 9:32 PM
    Monday, April 02, 2012 9:32 PM
  • Do you know if this process will work against user objects?

    I have a client who uses Quest which syncs users from a remote domain as user accounts in their domain. I have tried setting the msRTCSIP-PrimaryUserAddress and proxyAddress to include their SIP address, but Lync dosent pick them up as a external contact.

    Many thanks.

    Thursday, June 14, 2012 4:21 PM
  • Hi,

    Vytru Contacts Manager for Microsoft Lync (http://www.vytru.com/contacts-manager/) is the right solution for what you are looking for, using Contacts Manger is easy, start off by building a single unified contact list, or multiple contact lists, create groups, and then add contacts to the groups. Subsequently, you will populate the contact list to all your Lync users at once. Update your contact lists on a regular basis by adding new employees and removing those who left and push the updates to your Lync users.
    and to keep the contact list up to date with AD you might add DL rather than normal groups.

    Regards,

    Ahmed

    Thursday, December 13, 2012 3:18 PM