Remove duff contact from SQL directly RRS feed

  • Question


    Hello folks,

    I'm tyring to delete an unknown contact which was added in using the LCSaddcontacts script.

    (It's an unknown contact due to a typo)

    When i run the lcsaddcontacts script with the /delete switch to delete the contact I get an "invalid line" message every time.

    I have been told you can remove the dodgy contact from the SQL database itself.  Has anyone tried this and if so how did they do it?


    Thanks Very much for any help you can provide.

    Graham Coffer

    Network Admin


    Tuesday, March 25, 2008 3:07 PM

All replies

  • Now fixed.

    Wednesday, April 16, 2008 2:44 PM
  • I'm having this same problem, how did you fix it?


    Wednesday, April 30, 2008 10:49 PM
  • Hi mate, in order to remove the contact you need to look at the username in the communicator contact list very carefully, and take a note of the exact case of each letter.

    In my case, the problem was caused by the fact that my contacts file was like sip:fred.jones@domain.com but once this had been put into the contacts list using LCSAddcontacts it was appearing as Fred.Jones (capital F and J)


    If you modify the contacts file to reflect the exact Character case that it's seen as on the contact list in the communicator client, then the /delete should then work.


    See how you get on good luck.


    Thursday, May 1, 2008 11:43 AM
  • Thanks for the reply!  That was exactly the problem.  That really sucks, I was trying to set up an automatic script that ran every night.  What it did is build a contact list using dsquery.  Then every night it would delete the previous days contacts from everyone's list, then build a new contact list, then add the contacts back in again.  That way I wouldn't have to manually keep people's contact lists up to date as we added and deleted new users.


    Oh well, guess I just need to manually delete the users now and look at how it shows up in the contact lists.


    Thanks again!


    Thursday, May 1, 2008 3:32 PM
  • You may use   (OCSCM) Microsoft Office Communications Server Contact Manager.It's an administration mmc tool that will integrate with Microsoft Office Communication Server 2007 and Active Directory to provide an easy way to provision OCS users’ contacts list.   OCSCM is designed to show you how to manage the contacts and groups for individual ocs users by interacting with the Active Directory Domain Services and Microsoft Office Communication Server 2007/R2 and lcs 2005.

    download from http://www.ocscm.com

    Sunday, December 20, 2009 8:55 PM