Skip to main content

Active Directory Bulk User Import - Using DSAdd User

Need to get a lab live? If you are tired of waisting money and hours on Google searching for Active Directory User Import Tools and commands, just use this Excel File to run a bulk of users in a batch file from PowerShell or Command Prompt.

Here is the dsadd user command that will be created by the excel file by just adding your users and department OU sections:

dsadd user "cn=Migration King,ou=Users,ou=IT,ou=Departments,dc=us,dc=migrationking,dc=com" -fn Migration -ln Migration -samid MKing -upn MKing@migrationking.com -display "Migration King" -pwd P@ssw0rd -mustchpwd yes -disabled no

(For people that submit tweaks and fixes, please email support @ migrationking.com and we will add your edits and your name showing who submitted the correction/edits).
1. Option A: Sign into Google Docs and Copy the template. http://goo.gl/Lpsl7
1a. Option B. Download a local copy if you are still absolutely addicted to Microsoft Excel.
1b. Option C. Fill out the data, check it and then just export the Text File to Create the Batch file for AD.

2. Add Your Users and OU Information for your Department and Users (KISS as a rule for AD Departments)

3. Modify =CONCATENATE if you are overly complex and super corporate, if not drop in your data under "AddActiveDirectoryBulkUsers" sheet.

4. Check the "BulkUsersSourceFile" to see that data is populated correctly.

5. Review the "ExportTextFile" script lines for accuracy (saves a headache later). Then export.

6. Option A: Create a .bat file from Notepad File you exported and then run this from Command Prompt.

7. Option B: Spartan Style! Copy and Paste right into PowerShell Window

8. Verify accounts on your Domain Controller (onsite or via RackspaceCloud Servers if your in the cloud)

Booyaaahhhh!!! Your done. Wasn't that fast and easy? And you didn't have to crack out your credit card or beg your manager to buy you some complicated program for Active Directory Imports.

Now, start setting up Google Apps Directory Sync for Google Apps for Work Implementation.

* There are multiple options to use for Production environments at scale. Group policy has a lot of flexibility also. Here are some good programs for AD Import and Export:

Level I (I can rock this out during lunch!)
Levels II (I can get through this in a day or two...or three)
Levels III (OMG It's Complicated! WHAT were they thinking when they released this??!)

Level I. ActiveDirectory Import - http://www.activedirectoryexport.com/ScreenShots.aspx
Level II. ManageEngine - AD Bulk Users (Their URL is too long, here's a link)
Level III. ScriptLogic - http://www.scriptlogic.com/products/activeadmin/

PluralSight Training: http://goo.gl/roo8Y

* Everything here is best advice and at your own risk so if you break something, please don't blame us. Have fun! ~MigrationKing

Popular posts from this blog

How to Fix /storage/core filesystem Out of Disk Space Error on VCSA 6.0U1

How to fix the error of " The /storage/core filesystem is out of disk space or inodes" Step 1: Login to the new VCSA 6.0U1 HTML5 web client. https://ip address:5480 Step 2: Enable SSH and Bash Shell Step 3: Login as root and type "shell" at Command> shell Step 4: df -h (Check if it's out of space) /dev/mapper/core_vg-core               50G   50G     0 100% /storage/core Step 5: Stop the services of VCSA:  hostname: # service vmware-vpxd stop hostname: # service vmware-vpxd status (make sure it is stopped) Step 6:  cd /storage/core Step 7: rm -rf *.tgz ( be CAREFUL ...do this in the wrong directory and you will be retrieving from a backup .) If you need help. Go to Cybercity ( http://www.cyberciti.biz/faq/delete-all-files-folder-linux/ )  Step 8: service vmware-vpxd restart Step 9: history -c Step 10:  Refresh the browser (https://ip address:5480). Now it's all green VMware KB

VMware Tools ISO Does Not Exist

1. You attempt to Install VMware Tools and you get the following error: The required VMware Tools ISO image does not exist or is inaccessible. vix error code = 21001 Unable to install VMware Tools. An error occurred while trayin got access image file "/user'/lib/vmware/isoimages/windows.iso" needed to install VMware Tools: 2 (no such file or directory). Please refer the product documentation or KB article 2129825 for details....blah blah blah you get the point. First...that KB article is wrong. It's 1036810: https://kb.vmware.com/s/article/1036810 2. Go to the latest VMware Tools of your OS (You don't need to be logged in): https://packages.vmware.com/tools/esx/latest/index.html 3. Download the ISO and then WinSCP the file or whatever method you want to use to copy the file to /usr/lib/vmware/isoimages/ The quick and easy way is to just mount it and then install the VMware Tools. If you want to get gritty! Follow on! 4. If you don't

How to Login to AWS using CLI with AzureSSO through Azure Active Directory

Testing on Windows 10 Release 1909  Prerequisite (Install Visual Studio Code and the AWS CLI if you don't have it already installed and your Azure Active Directory is already configured and processing authentication) 1. Install Node.Js https://nodejs.org/en/ (Use the LTS Edition/Version) 2. Check the node version in PowerShell or Windows Terminal: node --version && npm --version 3. npm install -g aws-azure-login *install will take about 15-20 minutes. Be patient and let it finish.  4. Configure your profile aws-azure-login --configure --profile=<<Name of your profile>> Example:  aws-azure-login --configure --profile=migrationking Pro Tip: It installs the profile on your machine under ~/.aws/config . You can edit the file with Visual Studio Code or Notepad++ #This will prompt to Enter the Azure AD details *** Azure Tenant ID: << Enter the Azure AD Tenant ID from the Azure AD application configuration for the AWS Account to be accessed>> Azure Tenant I