Group Based Licensing for Multiple Users

vasudevkartheekakkur · 2018-05-01T15:18:05.000Z

I have a scenario where i need to take input from the CSV file for multiple users who have their UserprincipalName, Security Group and Action (Add or Remove).I need to write a power shell script to add the users automatically after taking the inputs from the CSV file.

UserPrincipalName, Secuirty Group, Action

test1,G1,Add

Test2,G2,Add … …

Tes20,G12,Remove

I used this for single user

Connect-MsolService

$groups = Get-MsolGroup -all -grouptype security | where {$_.DisplayName -eq “G1”}

$users = Get-MsolUser -all | where {$_.UserPrincipalName -like “Test*”}

$users | Foreach {Add-MsolGroupMember -GroupObjectId $group.objectid -GroupMemberType “user” -GroupMemberObjectId $_.objectid}

How would you do it for the above scenario for multiple users?

Rod-IT · 2018-05-01T15:46:43.000Z

I will get this moved, it has nothing to do with Spiceworks and would be better in PowerShell group

Rod-IT · 2018-05-01T16:06:16.000Z

By the way, what does groups have to do with licensing?

Neally · 2018-05-01T16:11:46.000Z

Welcome!

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

# code to connect to o365

foreach($user in (import-csv "c:\file.csv")){
   # code what to do here
}