The following macros are not currently supported in the header:
  • style

How to Add OneDrive sites to the Home Page Dashboard

This article applies to SharePoint Essentials Toolkit v6.1.3.0 and later

This article shows you how to manage OneDrive Site Collections from the Home Page Dashboard


Step-by-step guide

Download PowerShell Script here

  1. If you have not done so already, install the SharePoint Online PowerShell Modules here
  2. Open the SharePoint Essentials Toolkit
  3. Click Add Site, use your tenant my site URL, such as https://tenant-my.sharepoint.com
  4. Use a SharePoint Administrator account for the credentials
  5. Use options similar to below



  6. Click Add Site
  7. This will add all the OneDrive sites, but not the content
  8. Select all of the sites once listed:



  9. Press Ctrl+C (to Copy)
  10. Open MS Excel
  11. Press Ctrl+V to paste into Excel
  12. Copy the OneDrive URLs that you want to include in reports/manage
  13. Paste them into a text file
  14. Save the text file as onedrivesites.txt in same directory as the script.
  15. Open and update the script (such as enter Site Collection admin account to add to all OneDrives



  16. Run the script from PowerShell
  17. This will add the specified Site Collection Admin to all the OneDrive sites and you can now report / manage them
  18. To remove the site collection admins after, re-run the script but first change $true to $false










©2018 QiPoint
2500 Plaza 5, 25th Floor
Harborside Financial Center
Jersey City, NJ 07311 http://www.qipoint.com

Microsoft, Windows, SharePoint, and the SharePoint logos, are either registered trademarks or trademarks of Microsoft Corporation.