{"id":610,"date":"2015-03-10T19:34:13","date_gmt":"2015-03-10T18:34:13","guid":{"rendered":"https:\/\/www.em-soft.si\/myblog\/elvis\/?p=610"},"modified":"2015-03-10T19:34:13","modified_gmt":"2015-03-10T18:34:13","slug":"add-groups-and-users-to-ad-with-powershell","status":"publish","type":"post","link":"https:\/\/em-soft.si\/myblog\/elvis\/?p=610","title":{"rendered":"Add Groups and Users to AD with PowerShell"},"content":{"rendered":"

When I have to manage a bigger environment, with many groups and users, I always think to PowerShell<\/strong>. Of course, the first step to work with PowerShell is that you have all users or groups listed in a CSV (or similar) file. The first problem for many administrators is the structure of the CSV and data needed by AD. I want to talk about this, because CSV stands for comma separated value<\/strong>, what means that all fields are separated by comma. Nothing strange or new, but as we know also AD structure is using commas to delaminate OU\u2019s, domains etc<\/strong>. Because of this, please be careful when you create your CSV file. I prefer to create CSV file with semicolon as delimiter<\/strong> and then all the things are going right.<\/span>
\nThe second step that I use is to create at maximum three CSV files<\/strong>; one containing new AD groups, the second containing Group nesting (groups that are members of groups) and the last one containing users (Users and groups that have to be members). If you receive that data form other sources, be careful and first just test if all data are correct (if users really exist, if there is no typing error) and after this step begin with the implementation. This could be done with the same script, just delete the lines that contains write actions and export results in a test file for the future control.<\/span>
\nCreating a CSV files: For me, the best program to create CSV files is Microsoft Excel<\/strong>. Everyone knows the program in the way that can type names and some data in (not all, you will have to type some attributes yourself) I always use the same structure of CSV and for this reason I never have problem with the script. Fundamentally is first line, where you have to define columns. So there are my columns:<\/span><\/p>\n

For Groups CSV<\/strong><\/em> (New groups to be created):<\/span><\/p>\n