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?