[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Delete Msol groups from csv file

Posted on 2016-10-04
6
Medium Priority
?
116 Views
Last Modified: 2016-10-04
I'm migrating all our distribution Groups that are managed from our on premises exchange server, to O365, but we are having issues with the Sync , so , some groups are not syncing correctly with O365 and are not been deleted. I need to delete then completely to re-create them later.
The only command that seems to work for me now is:
Get-MsolGroup -SearchString "Group Name" | ft *name,objectId
And then copy the object ID and do:
Remove-MsolGroup -ObjectId   xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
I'm trying to use something like the following but is not working:
Import-CSV C:\Path\DGtodelete.csv |ForEach {Get-MsolGroup -SearchString $._Name | select *name,objectId} | Export-Csv C:\Path\objectId.csv -NoTypeInformation       ### it gives me errors
Import-CSV C:\path\DGtodelete.csv | ForEach {Remove-MsolGroup -ObjectId $._ObjectId}        #### also errors
Please , help me to to have this working
Thanks,
0
Comment
Question by:Ernesto Gallardo
  • 3
  • 3
6 Comments
 
LVL 40

Accepted Solution

by:
Subsun earned 2000 total points
ID: 41828413
It could be the syntax error.. $._ObjectId will give error..  $_.ObjectId should correct it
Import-CSV C:\Path\DGtodelete.csv |ForEach {Get-MsolGroup -SearchString $_.Name | select name,objectId} | Export-Csv C:\Path\objectId.csv -NoTypeInformation

Import-CSV C:\path\DGtodelete.csv | ForEach {Remove-MsolGroup -ObjectId $_.ObjectId}

Open in new window

1
 

Author Comment

by:Ernesto Gallardo
ID: 41828465
Thank you very much for your help. For the first one it worked perfectly , It created the objectId.csv file with the objectId for every DG in DGtodelete.csv. So when i run the second one :

Import-CSV C:\Cygwin\DGtodelete.csv | ForEach {Remove-MsolGroup -ObjectId $_.ObjectId}

 I get this error:

Remove-MsolGroup : Cannot bind parameter 'ObjectId'. Cannot convert value "" to type "System.Guid". Error: "Unrecognized Guid format."
At line:1 char:75
+ ... win\DGtodelete.csv | ForEach {Remove-MsolGroup -ObjectId $_.ObjectId}
+                                                              ~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Remove-MsolGroup], ParameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.Online.Administration.Automation.RemoveGroup
 And i don't understand why, it is supposed to be very simple cause if you do it one by one:

Remove-MsolGroup -ObjectId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx   ...It works fine
 Any thoughts,
Thanks again
0
 
LVL 40

Expert Comment

by:Subsun
ID: 41828478
If the input csv file displays correct GUID then try..
Import-CSV C:\path\DGtodelete.csv | ForEach {$GUID = [GUID]$_.ObjectId ; Remove-MsolGroup -ObjectId $GUID}

Open in new window

1
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 

Author Comment

by:Ernesto Gallardo
ID: 41828519
Ohh Yes, it worked perfectly. Thank you so much for your help.  the only thing was change the file name to objectId.csv  ..
Thanks again
0
 

Author Comment

by:Ernesto Gallardo
ID: 41828525
You have just saved me a lot of time and effort
0
 
LVL 40

Expert Comment

by:Subsun
ID: 41828590
You are welcome!, Don't forget to close the question! :-)
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Loops Section Overview
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question