SharePoint Online: Get Subsite Permission Report using PowerShell

Requirement: PowerShell script to get subsite permissions in SharePoint Online How to Get Subsite Permissions in SharePoint Online? To get permissions of a SharePoint Online subsite, Click on Setting gear >> Click on the “Site Permissions” link Click on “Advanced Permission Settings” in the site permissions page This gives you all users…

Read more

SharePoint Online: Find All Files Exceeding Maximum URL Length Limitation using PowerShell

Microsoft Office Excel files stored in deep Folder, sub-folder structures with long names often result in an error when they exceed the maximum file URL length of 218 characters as in my other article  SharePoint Online: URL Length Limitation of 218 Characters in Excel Files. So, we wanted to proactively scan the…

Read more

SharePoint Online: Export Access Requests Settings using PowerShell

Requirement: Export access requests settings for all sites in SharePoint Online using PowerShell SharePoint Online: PowerShell to Export Access Requests Settings (Email Address, Group Configuration) To export access requests settings from all sites in the SharePoint Online tenant, use this PowerShell: This PowerShell script gets the inventory of all access request settings…

Read more

Get Documents Inventory for a Site Collection using PowerShell

Requirement: Get All documents inventory in a CSV format from a SharePoint Site collection. PowerShell to Get Documents Inventory of a SharePoint Site: This PowerShell gets all document details from a given site. To generate a report on all documents in a SharePoint Online site collection, use: SharePoint Online: Get All Documents…

Read more

Generate SharePoint Online Site Usage Reports using Graph API and PowerShell

Requirement: Generate usage reports for SharePoint Online sites. How to Generate Usage Reports for All SharePoint Online Sites in the Tenant? From Microsoft 365 admin portal you can export the usage data in CSV format. To get usage and activity reports for all SharePoint Online sites, follow these steps: Navigate to Microsoft…

Read more

SharePoint Online: Site Documents Inventory (Library, Folder, Sub-Folder and Files) Report using PowerShell

Requirement: Generate an Inventory report that contains all document Libraries, Folders, Sub-Folders, and Files detail from a SharePoint Online site collection. SharePoint Online: Site Inventory Report using PowerShell We wanted to find the number of files and folders, sub-folders in each document library in a SharePoint Online site. This PowerShell script extracts…

Read more

SharePoint Online: User Permissions Audit Report for a Site Collection using PnP PowerShell

Requirement: Need a report to audit SharePoint Online site collection permissions. SharePoint Online: User Permissions report in a Site Collection using PnP PowerShell Auditing SharePoint Online Site permissions is critical for security as misconfigured permissions may enable users to access to data that they should not have access to. So, regular auditing…

Read more

SharePoint Online: Find All Unused Sites based on Last Modified Date

Requirement: Get All Unused SharePoint Online Sites How to Find the Last Modified Date of SharePoint Online Site Collections? The modern SharePoint Online Admin center gives a neat view of all sites in the tenant along with the “Last Activity (UTC)” column that gives a date value when List Items or Files…

Read more

Office 365: Get OneDrive for Business Usage Report using PowerShell

Requirement: Get OneDrive for business usage report using PowerShell How to Check the OneDrive for Business Usage for a User in Office 365? OneDrive for Business is Microsoft’s cloud-based storage solution that lets you store and work on files that are personal to you. It’s similar to any other document library in SharePoint…

Read more

SharePoint Online: Find All Folders Exceeding List View Threshold Limit of 5000

Problem: Any SharePoint List, Library, or Folder contains more than 5000 items at the same level results list view threshold exceeded error messages in SharePoint Online. While the maximum number of items or files that can be stored in the SharePoint Online list or library is 30 million, more than 5000 items…

Read more