For a recent customer case, we needed a meta-data export of ALL files in the entire O365 tenant, filenames, dates, modifications, sizes and unique ID’s.

It is tricky to actually get everything (Teams especially) and to handle any MFA you may (SHOULD!!) have configured on your admin accounts, but here you are:

https://gitlab.com/Lieben/assortedFunctions/blob/master/export-allO365FilesToCsv.ps1

Note that your admin account does have to have permissions on all sources the script identifies.

Many Office 365 clients (and especially Excel) really don’t like long paths. The older the client, the worse the issues.

To find files over a certain path length in Office 365, I wrote a script a while back. This required manual perusal of the results and manual correction of the issues.

The new version of my script now features fully automatic discovery, a flexible editor and automatic correction of paths based on what you entered into the editor.

You can get the PowerShell script / editor from my git repository here.

Many thanks to CTS in their help me designing and testing this script!

How to use

1. download the script and save it somewhere
2. Copy the desired Sharepoint Library into a new Sharepoint Library and/or site
3. Run the script only for that site or library by specifying the -specificSiteUrls or specificDocumentLibraries parameter
4. do some corrections, commit them, check the results
5. If satisfied, set permissions for your admin account on the actual production locations your wish to fix (script for Onedrive Mass Permissions here)
6. Ensure no users have open files in the library
7. Remove any non-standard characters from folder names (see script source, example code at the top)
8. Run

Disclaimer

• Please make sure you TEST this on a copy of your document library/sites before using the ‘commit’ option.
• Use at your own risk.
• I recommend turning on the Universal Audit log before usage.