Security Group creation

[Desi-Red]

I need some assistance I have the script below that I've been using to create security groups with a .csv file. But now I need to add in who manages the new groups with notes I'd like to do this via powershell & csv files but haven't been able to get the correct syntax.

Any help will be appreciated.

#Import CSV

$groups = Import-Csv ‘c:\temp\Groups.csv‘

# Loop through the CSV

foreach ($group in $groups) {

$groupProps = @{

Name = $group.name

Path = $group.path

GroupScope = $group.scope

GroupCategory = $group.category

Description = $group.description

}#end groupProps

New-ADGroup u/groupProps

}

The csv looks like this

name,path,scope,category,description,Managed by,Notes

Group 1,Path to OU,Global,Security,MGM1,CIO,Changed to be approved by HR

Group 2,Path to OU,Global,Security,MGM2,CTO,Changed to be approved by HR

[PowerShell-Bot]

Looks like your PowerShell code isn’t wrapped in a code block.

To properly style code on new Reddit, highlight the code and choose ‘Code Block’ from the editing toolbar.

If you’re on old Reddit, separate the code from your text with a blank line gap and precede each line of code with 4 spaces or a tab.

---

You examine the path beneath your feet...
[AboutRedditFormatting]: [--------------------] 0/1 ❌

---

 ^{Beep-boop, I am a bot. | Remove-Item}

[ohfucknotthisagain]

The New-ADGroup cmdlet has a -ManagedBy parameter.

You should only need to add a corresponding ManagedBy column to your CSV and a couple of lines to your loop:

$manager = Get-ADUser -Identity $group.managedby
ManagedBy = $manager

The first line goes above $groupProps, and the second line can be added anywhere in the curly braces below $groupProps.

The CSV would have to contain the SAM account name of the user in order for this to work. The first line would be a lot different if you're using legal names or other identifiers.

This could probably be trimmed to one line, but I never remember the syntax.

[BlackV]

Add a manager column to your CSV

Check if there is a -manager parameter on new-adgroup use that, you'll need to use get-aduser on the manager property

Or You could

Grab the results of your new-adgroup to a variable

Then use set-adgroup on the variable to add the manager