Error when identifying user login "-Identity"

Question

I made this simple script to remove a particular group from AD users via .csv but is accusing error that the $_.user has not been identified or is empty.

Import-Csv -Path "C:\Users\antonio.costa\Documents\office365\vpn.csv"

ForEach {
Remove-ADPrincipalGroupMembership -Identity $_.user -MemberOf "Acesso_vpn"
}
break

This break I added to see it stopping on the screen, but besides giving the error and not stop, already closes soon.

Answer 1

You have that task mentioned in that article/link: https://www.petenetlive.com/KB/Article/0001475

---

• 1) note the use of Foreach-Object , and not the Foreach

• 2) note the use of $.'User-Name' , and not the $.User

---

Import-Csv -Path "C:\Users\antonio.costa\Documents\office365\vpn.csv" | ForEach-Object {Remove-ADGroupMember -Identity "Acesso_vpn" -Member $_.'User-Name' -Confirm:$false }

# ou #

ipcsv -Path "C:\Users\antonio.costa\Documents\office365\vpn.csv" | % {Remove-ADGroupMember -Identity "Acesso_vpn" -Member $_.'User-Name' -Confirm:$false }

---

It is suggested to visit this question of the Soen: Q29148462

---