How to bulk rename items in SharePoint Online and OneDrive for Business

In this article, we examine some basis examples for renaming items (files) stored in SharePoint Online or OneDrive for Business, in bulk. The code samples leverage the Graph SDK for PowerShell’s cmdlet, and a sample using PnP PowerShell is provided as well. As for the scenarios we cover, we start with a simple rename to lowercase, followed by CSV-based example and an example that leverages both the item’s properties and fields. …

Continue readingHow to bulk rename items in SharePoint Online and OneDrive for Business

Reporting on unlicensed OneDrive (for Business) accounts in Microsoft 365

Last year, Microsoft announced plans to start charging tenants for data stored in unlicensed OneDrives, that is drives that belong to unlicensed Microsoft 365 users. Unlike Exchange Online, where inactive mailboxes provide you with essentially free retention for the duration of any hold/policies assigned to the user, the functionality to …

Continue readingReporting on unlicensed OneDrive (for Business) accounts in Microsoft 365

Remove all sharing links and permissions for items in SharePoint Online or OneDrive for Business

A “proof of concept” script that you can use to remove all sharing links (sharing permissions) across all items stored in SharePoint Online and OneDrive for Business, including Teams sites. The script is indented to be run non-interactively and requires Sites.ReadWrite.All application permissions. …

Continue readingRemove all sharing links and permissions for items in SharePoint Online or OneDrive for Business

Reporting on SharePoint Online and OneDrive for Business item size with version history included using the Graph API

A Graph API based PowerShell script to report on storage usage in SharePoint Online and OneDrive for Business. The script allows you to generate a report down to individual items, with version history included, and can generate output resembling that of the Storage Metrics tool. You can run it against a single site, set of sites or all sites. …

Continue readingReporting on SharePoint Online and OneDrive for Business item size with version history included using the Graph API

My experience working with SharePoint/OneDrive for Business item versions via the Graph API

Before we get started, be warned – this is a rant post. While there are some interesting examples and potentially even some learnings you can find below, the post will predominantly focus on my frustration with (some of) the SharePoint Online endpoints on the Graph API. If you have more …

Continue readingMy experience working with SharePoint/OneDrive for Business item versions via the Graph API