Delete bulk AD account from text file

Posted on 2008-11-10
Last Modified: 2012-06-27
Can someone help me with a script? I need a script to delete bulk AD contacts from text file. In text file the script has to read line by line. On each line there is a proxyaddress, the script has to find these proxyaddresses in AD and after delete it.

Question by:jefmelkenbeek
    LVL 10

    Expert Comment

    * If you could use a csv file instead of a text file and then you might want to check the ADManager Plus tool from ManageEngine for this task:

    Good Luck (^_^)

    Author Comment

    this is not what I'm looking for. I have already seen many bulk tools, but i have my own order of attributes in my csv or text file.

    Author Comment

    I was looking for another answer.
    Is it possible to refund the points back?
    LVL 10

    Accepted Solution

    * Sorry for the delay in getting back:

    * Heres a script that could do the task:
    Option Explicit
    Dim oFSO, sFile, oFile, sText, obj
    Set oFSO = CreateObject("Scripting.FileSystemObject")
    Set obj = GetObject("LDAP://CN=Users,dc=eu,dc=com")
    sFile = "C:\Documents and Settings\Administrator.APDC01\Desktop\inputfile.txt"
    If oFSO.FileExists(sFile) Then
    Set oFile = oFSO.OpenTextFile(sFile, 1)
     Do While Not oFile.AtEndOfStream
      sText = oFile.ReadLine
       If Trim(sText) <> "" Then
        Msgbox sText
        obj.Delete "user", "cn="&sText
       End If
    WScript.Echo "The file was not there."
    End If

    Open in new window

    LVL 10

    Expert Comment

    * Now in the above script;

    * In line number 4: Replace the OU and domain structure as per your organization

    * In line number 5: Replace the input file name and path for the same with your input file.

    * In Line number 12, the attribute that has been taken into consideration is the Cannonical Name (CN) of the user property. Here you can replace it with any of the attributes that you want or is there in the input text file for the users; i.e. it may be the "mail" attribute (for email address) or the DN attribute for the distinguished name etc.

    * And finally to see what all attributes for a user object is supported you can use a low level editing tool like ADSIEdit.msc and then using it drill down to the user obect as depicted in the ADUC console (you would find it in the domain partition part of the Adsiedit console) and the right click on that user and say properties and there check the box which says attributes with values and you can find all the attributes there.

    Hope this helps (^_^)

    Author Comment

    Hello Rudram,

    thanks a lot for your reponse.I will test it tomorrow:) and will let you know the result.

    Author Closing Comment

    Thanks for your code :).
    it did the trick

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
    This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now