<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
Wondering if someone could generate some good Powershell to try and achieve the following.<br />
<br />
I've just inherited a messy AD and need to organise it. There's just one OU full of security groups with no indication of what they actually do. <br />
<br />
I'm trying to recreate the groups with a bit more structure E.g. SYSadmin role on a SQLServer1 the security group would be SQL - SysAdmin on SQLSERVER1<br />
<br />
What I need is a spreadsheet where I can specify the legacy security group in one column and the new security group whereby all the members of the legacy security group need to be copied into, in the next column. I also need it to create the security group if it doesn't already exist and the newly created security groups need to go into one specific OU and I'll sort them once done.<br />
<br />
Can anyone generate a good powershell script for this?<br />
<br />
Cheers!<br />
<br />
Jack
</div>
</div>


Hi Guys,

Wondering if someone could generate some good Powershell to try and achieve the following.

I've just inherited a messy AD and need to organise it. There's just one OU full of security groups with no indication of what they actually do. 

I'm trying to recreate the groups with a bit more structure E.g. SYSadmin role on a SQLServer1 the security group would be SQL - SysAdmin on SQLSERVER1

What I need is a spreadsheet where I can specify the legacy security group in one column and the new security group whereby all the members of the legacy security group need to be copied into, in the next column. I also need it to create the security group if it doesn't already exist and the newly created security groups need to go into one specific OU and I'll sort them once done.

Can anyone generate a good powershell script for this?

Cheers!

Jack

Security Groups with Powershell &amp; CSV

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Security Groups with Powershell &amp; CSV

Security Groups with Powershell & CSV