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:
Note that your admin account does have to have
permissions on all sources the script identifies.
Pivot table of all Microsoft cloud suites and their features
I’ve updated the
Microsoft cloud suites feature comparison page with all other suites Microsoft including all their features. I’ve also added all Education sku’s. You can use the pivot table to sort / mix / match according to your exact needs. If you need any assistance with Microsoft 365, don’t be a stranger 🙂
A full overview of all Microsoft 365 (Business, F1, E3 and E5) plans and their features in a table for your convenience 🙂
Many Office 365 clients (and especially Excel) really don’t like long paths. The older the client, the worse the issues.
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.
Correcting path lengths in Sharepoint Online, Onedrive for Business and Microsoft Teams
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
download the script and save it somewhere Copy the desired Sharepoint Library into a new Sharepoint Library and/or site Run the script only for that site or library by specifying the -specificSiteUrls or specificDocumentLibraries parameter do some corrections, commit them, check the results If satisfied, set permissions for your admin account on the actual production locations your wish to fix ( script for Onedrive Mass Permissions here) Ensure no users have open files in the library Remove any non-standard characters from folder names (see script source, example code at the top) Run
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.
In the post-Onedrivemapper era where we have Files On Demand, there is still room for improvement in client side configuration of Onedrive for Business. Onedrive Known Folders isn’t up to par yet, doesn’t support any customization and there are situations where I want to be able to redirect local folders to other places than Onedrive like Teams or Sharepoint.
Therefore I present to you “
Invoke-O4BAutoMount“; the ultimate Onedrive/Sharepoint/Teams sync and redirect solution in modern workplace scenario’s, no WebDav, just the NSG Onedrive Client and native Intune Management Extension: Continue reading Ultimate folder redirection for Onedrive, Teams and Sharepoint