Category Archives: PnP.PowerShell

How to download ‘ALL’ files from a very large document library?

Summary My customer had a large document library on SharePoint Online with a deep folder structure. The total number of items is 2.7 million (2,743,321). They want those documents downloaded to the local folder. I know, this is an actual … Continue reading

Posted in MS Graph, PnP.PowerShell, SharePoint, SharePoint 2013, Technical Stuff | Leave a comment

How to turn on versioning on ALL document libraries for a site?

Summary The requirement is to turn on versioning for all site document libraries, including subsites. Also, the Major version number should be 500. The following Set-PnPList command can be used to set the Versioning and Major version as 500 for … Continue reading

Posted in PnP.PowerShell, SharePoint | Leave a comment

How to get SharePoint audit reports using Office 365 Management APIs?

Summary The following are the customer concerns with the SharePoint sites on Microsoft 365 cloud regarding audit reports. SPO site collection admins do not receive the same GUI presentation for site audit reports that were available on the SharePoint on-premises. … Continue reading

Posted in PnP.PowerShell, SharePoint 2010, SharePoint 2013, Technical Stuff | 1 Comment

How to get a list of Site Collection Admins for a SharePoint site?

Summary My customer had a requirement to get the list of Site Collection Admins (SCAs) for any site within the tenant for anyone in the organization. The need of the user is to find additional information from the SCA. This … Continue reading

Posted in Azure, PnP.PowerShell, SharePoint | Leave a comment

How to automate and govern the “Sites.Selected” permissions using a custom tool?

Summary Earlier, I posted an article regarding the “Sites.Selected” MS Graph permission to create the granular permissions for sites. The following is the link for the article. How does the MS Graph “Sites.Selected” permission work for granular permissions for SPO … Continue reading

Posted in Azure, PnP.PowerShell, SharePoint | 2 Comments

How does the MS Graph “Sites.Selected” permission work for granular permissions for SPO sites?

Summary To provide granular access for the sites the Azure Access Control (ACS) was used in the past. The app id and secret can be created using the add-ins, more info is described here. Note: Please check ACS retirement info. … Continue reading

Posted in PnP.PowerShell, SharePoint | 7 Comments

How to get raw data from PFX certificates?

Summary This article will show the step-by-step PowerShell commands to read the raw data from the certificate. Prerequesite is you need to create a sample PFX file. It is very easy to create such files using the PnP Powershell module. … Continue reading

Posted in PnP.PowerShell, SharePoint, Technical Stuff | Leave a comment

How to add custom banner to alert “SharePoint 2010 workflow retirement” to site users and owners?

Summary The SharePoint 2010 workflow will retire. Microsoft announced it, see the following link. SharePoint 2010 workflow retirement For my customer, even after multiple messages to the Admins and Owners there was not an immediate action taken by the owners. … Continue reading

Posted in PnP.PowerShell, SharePoint, SharePoint 2010, SharePoint 2013 | Leave a comment

How to get User Profile Properties and ODfB information?

Summary I want to find out the User’s OneDrive for Business url or personal site. I also want to find more such user properties for the user with UPN, such as when the personal site created, if not created what … Continue reading

Posted in PnP.PowerShell | Leave a comment

How to setup certificate in MAG Azure Function App for PnP.PowerShell?

Summary The PnP.PowerShell supports PowerShell Core. There are few things you must do to make the PowerShell Code to work in Azure Function App. In this article, I will go through the steps by step all pre requisites. Step by … Continue reading

Posted in MS Graph, PnP.PowerShell | 3 Comments