Cleaning up School Data Sync

[cooper549]

I've been trying to clean up our O365 SDS implementation for a few days now but the method I thought would work no longer does.

 

When testing, I've run a fresh section report, removed everything that needs to stay and marked the status columns with 'tobedeleted' as per what was on the CSV, but this was only in a small test when trying to figure out a method to remove over 1500 sections that are no longer needed.

 

I'm 100% sure on one of the section reports I've done in the past, the status column was filled with 'tobedeleted' in a number of rows, and when testing, I remember this working. However, I've lost the CSV file I originally tested this with and trying this by just typing it in doesn't work, which makes me a think I've got it wrong.

 

None of the documentation I can find online explains this functionality which is driving me more insane because I remember it so vividly working thinking I'd solved all my problems.

 

Has anybody else seen anything like this or how does everyone else cleanup SDS? It's mildly infuriating that there is no option to just plainly delete multiple sections/groups without having to PowerShell it.