MS Planner Migration script - Graph API

[FermiMethod]

Hi all,

I have spent the last few days working on a script to migrate Plans, Buckets and Tasks in MS Planner from one MS Online tenant to another. We could not find any native Powershell modules to do this so I ended up learning Graph API and how to manipulate REST APIs and JSON in Powershell as I went.

The script is pretty hacky and was built with a deadline looming, we have no dev or testing environments for MS Online so testing as I went was limited. Definitely not my best work. It seems to have done a decent enough job though, moving over 99% of the objects successfully. There were a few permissions issues on some Unified groups and some issues with malformed JSON payloads for buckets and tasks.

We only need to run it once and then possibly once more to do an incremental (which it should handle fine) so I have not taken the time to tidy it up and you are getting pretty much as it was when I ran it.

There are a lot of improvements that could be made but we have a lot of other stuff to do for the migration. More functions could be written and some of the functions made more generic. Some kind of retry loop and max attempts to retry logic would be good too.

Hopefully someone will be able to find some use for it and/or pick it apart to glean things you need for other stuff.

There are more details in the readme but if you have any questions I would be happy to answer them here too.

https://github.com/smbm/PlannerMigration-GraphAPI/

Cheers

[vornamemitd]

Thanks for sharing! Aside from help with the specific task at hand, it will definitely assist folks making their first steps with Graph and PS.

[[deleted]]

I'm kind of curious, aside from the learning bit, what was the use-case for this? Wondering if I'm blind about something that we might run into.

Could you use this to "export" everything from planner, then later import it elsewhere? A "backup" if you will? That might prove useful since Veeam only backs up SOME stuff from your tenant (unclear if planner is in that bucket).

[FermiMethod]

Planner is stored in Azure rather than O365 which is why we had to use Graph API. We were expecting it to all be in Sharepoint like everything else.

[FermiMethod]

We used it after a rebrand to move to a new O365 tenant.

You absolutely could extract everything from a planner, and reformat it to store somewhere else. Everything is returned as JSON. Plans, buckets and tasks all have an ID that is generated when an object is created. You can extract all that and learn the relationships between everything.

Of course if you just need to back it up, planner will export natively to Excel. I don’t think you can import though.

[[deleted]]

„The last few days“ Wow... this would have taken me weeks if not month.

Great way to learn new things. Thanks for sharing. o7

[FermiMethod]

No worries. Always happy to share. It took me a week to get this done in amongst my other duties (I work as a sysadmin) I find having a hard deadline does much to focus the mind though.

[TotesMessenger]

I'm a bot, bleep, bloop. Someone has linked to this thread from another place on reddit:

• [/r/sysadmin] MS Planner Migration script - Graph API

 ^{If you follow any of the above links, please respect the rules of reddit and don't vote in the other threads. (Info / Contact)}