Data Migration

[atechguy]

Hi All,

 

Just wondering if anyone has come across a PowerShell script that would allow me to extract a list of users OneDrive URL and link it to the AD usernames in a csv.

 

Currently i have 900 users OneDrive URLs in a csv. But going through 900 users and linking their profile file shares is going to take forever.

 

Anyone got any genius ideas for this?

 

Thanks

[psydii]

Excel, split the url (text to columns)

 

One of the columns should be the username assuming you have the samaccountname or the upn matching the 365 username / email

[atechguy]

samaccountname matches 365 yes

 

mydomain-my.sharepoint.com/personal/F_surname_domain_co_uk - Not sure how i would split this in excel though

Edited September 24, 2021 by atechguy

[psydii]

open the csv in excel.

do to the data tab

click text to column button

use / as the delimitator.

Then spilt again on a suitable delimitator to isolate the username.

[DaveTheTech]

Search for my post on this.It will do just that!

 

ALthough I suggest that you redirect documents etc to OneDrive.

The post explains everything. And whilst the script wasnt meant for public consumption, is up on GitHub.

Edited September 24, 2021 by DaveTheTech

[atechguy]

Thanks

 

A known folder move GPO is (was) in place. But.... i obviously cant remove the redirection policy until data is migrated. Smaller numbers of users have been migrated. Its just the students that are the harder to get migrated (time)

 

Thanks for pointing me towards the PS Script. Ill take a look.

Edited September 24, 2021 by atechguy

[DaveTheTech]

I thought that known folder move didnt work whilst folder redirection was inplace?

I used a mixture of the SharePoint Migration Tool and "users can sort themselves out". This was purely because staff had started using it and had partially moved documents over.

[atechguy]

I thought that known folder move didn't work whilst folder redirection was inplace?

I used a mixture of the SharePoint Migration Tool and "users can sort themselves out". This was purely because staff had started using it and had partially moved documents over.

 

Exactly that. It doesn't work with Folder Redirection in place. I've enabled Silent Sign in. But removed Known Folder Move until data fully migrated.

 

Staff are migrated. Its just the amount of students to migrated from different file shares.