Update CSOM PowerShell Scripts To Utilize Oauth

I have been scripting from longtime and as a result I have so many automations that are using Sharepoint CSOM, I only recently started utilizing PNP as new version of PNP utilized Oauth. Reference: The way PnP PowerShell authenticates you to your tenant has changed. We now use OAuth behind the scenes to authenticate you.…

Export Sharepoint Online List Items – Python

As I am continuing my Python journey so sharing a script that will export the Sharepoint List items to CSV file. We have seen scripts like these with Powershell but this is for python lovers Here is the Script that you can download from Github. (Tested on Python 3.8.5) https://github.com/VikasSukhija/Python/blob/main/ListExportSPO.py Libraries used: CSV Office365-REST-Python-Client Demo…

Set Onedrive Quota from file or AD Group

Lets do a magic this time with Onedrive quota. Requirement: We have updated the default quota for all E3 Onedrive sites up to max limit that Microsoft allows that is 5 TB. We thought that onedrive for all users will update with new quota automatically but it was not the case, on the contrary in…

List all OneDrive Sites V2 – HTML Report

This is the version two of my earlier script that I shared back in 2018. https://techwizard.cloud/2018/09/24/list-all-onedrive-sites-html-report/ New requirement came from one of our team is if we can show: Storage sage of onedrive for user Storage Quota assigned Percentage of storage used. Script will collect all the onedrive urls and save it in HTML table…