You spent last month turning Restricted Content Discovery on, site by site, to keep the messy ones out of Copilot. Now someone asks a fair question: which sites did we actually restrict? Clicking through Active sites one at a time is not the answer. PowerShell gives you two clean ways to get it, one site…
The admin enables the Restricted SharePoint Search feature to make sure that Copilot does not go to the dirty sites that have not been cleaned up yet, informs the boss that everything is done, and in just one week, the helpdesk has a dozen tickets with the subject of “I cannot find anything using search.”…
A tenant user logs into Copilot, tells Copilot to summarize last quarter’s data and Copilot returns a number from a workbook that he/she wasn’t supposed to access. All along the permission was there; no one saw it as SharePoint has no unified view that answers the one question that an admin always needs answered –…
PnP for SharePoint, Graph for everything else – but PnP ships Invoke-PnPGraphMethod, so it can call any Graph endpoint. Why ‘which module’ is often the wrong question, and the support difference that decides it in enterprises.
Sharing links are the quietest oversharing vector in SharePoint, and Copilot will surface every forgotten one. I built a free PowerShell tool to find them tenant-wide, rate the risk, and revoke the bad ones. Here is how to use it.
Get-PnPList returns 19 lists on a site with four. ItemCount counts folders as items, so it is not your file count. And the fast way to get storage beats summing files by a margin that grows with every document.
Your script asks for a column by the name on screen and gets an empty string back. Every column has two names, renaming never changes the one that matters, and Created By is called Author.
Updating a SharePoint list from a CSV fails in three ways, two of them silently: an invalid Choice value is written without complaint, an empty cell deletes data, and one bad cell loses the whole row. With the script that catches all three.
How to report everyone with access to a SharePoint site, and why the two obvious approaches are both wrong – one flags every site as overshared, the other stays silent while the whole company has Edit.
A tenant-wide site inventory with PowerShell, and why the owner column is harder than it looks: three of the four owner properties are empty on every site, and every group-connected site reports no owner at all.