Tag: PowerShell

Counting Microsoft Entra ID (Azure Active Directory) Groups

Groups and Permissions If you use Microsoft Graph Data Connect for SharePoint, you know that the datasets from SharePoint will give detailed permissions, including which users have access to sites, libraries, folders and files. However, permissions are frequently granted to Microsoft Entra ID (new name for Azure Active Directory) groups. To fully understand how many … Continue reading Counting Microsoft Entra ID (Azure Active Directory) Groups →

SharePoint on MGDC FAQ: What is the size of my sites?

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Introduction How much storage is being used by your SharePoint sites? Sounds like a simple question, but there are lots of details … Continue reading SharePoint on MGDC FAQ: What is the size of my sites? →

PowerShell cmdlets and parameters for the SharePoint Online module

This is a simple list of all the cmdlets in the Microsoft.Online.SharePoint.PowerShell module. This is a useful module for an Administrator using SharePoint Online or OneDrive for Business. Here are a few notes: If you don't have the module, you can install it using the following cmdlet: Install-Module -Name Microsoft.Online.SharePoint.PowerShell Before you can use most … Continue reading PowerShell cmdlets and parameters for the SharePoint Online module →

PowerShell Examples in my GitHub Repo

I just uploaded a few of my PowerShell samples to GitHub at https://github.com/Jose-Barreto/PowerShell. Many were mentioned in previous blog posts: PowerShell Examples: Calculating the value of Pi PowerShell Examples: Calculating Prime Numbers PowerShell Examples: Generating Random Names PowerShell Examples: Counting words in a text file PowerShell Examples – Random words and their popularity via Bing PowerShell Examples: Using Bing to … Continue reading PowerShell Examples in my GitHub Repo →

Using PowerShell to generate a large test CSV file with random data

I recently posted a new blog that shows how to load a very large CSV file into Excel, breaking the limit of 1 million rows in a single Excel sheet. If you haven't seen it, you should check it out: Loading CSV/text files with more than a million rows into Excel. One of the challenges for … Continue reading Using PowerShell to generate a large test CSV file with random data →

PowerShell script organizes pictures in your OneDrive camera roll folder

I just published a new PowerShell script that organizes pictures in your OneDrive camera roll folder. It creates folders named after the year and month, then moves picture files to them. Existing files will be renamed in case of conflict. Empty folders left behind after the files are moved will be removed. It defaults to … Continue reading PowerShell script organizes pictures in your OneDrive camera roll folder →

PowerShell for finding the size of your local OneDrive folder

I would just like to share a couple of PowerShell scripts to find the size of your local OneDrive folder. Note that this just looks at folders structures and does not interact with the OneDrive sync client or the OneDrive service. First, a one-liner to show the total files, bytes and GBs under the local OneDrive … Continue reading PowerShell for finding the size of your local OneDrive folder →

Drive Performance Report Generator – PowerShell script using DiskSpd by Arnaud Torres

Arnaud Torres is a Senior Premier Field Engineer at Microsoft in France who sent me the PowerShell script below called "Drive Performance Report Generator".He created the script to test a wide range of profiles in one run to allow people to build a baseline of their storage using DiskSpd.EXE.The script is written in PowerShell v1 and … Continue reading Drive Performance Report Generator – PowerShell script using DiskSpd by Arnaud Torres →

Using PowerShell and Excel PivotTables to understand the files on your disk

  Introduction I am a big fan of two specific technologies that usually don’t get mentioned together: PowerShell and Excel PivotTables. It started when I was explaining PivotTables to someone and the main issue I had was finding a good set of example data that is familiar to everyone. That’s when it hit me. People … Continue reading Using PowerShell and Excel PivotTables to understand the files on your disk →