PowerShell

Latest Articles

Practical Graph: Incomplete Task Analysis for Planner Tasks

Practical Graph: Incomplete Task Analysis for Planner Tasks

In the first article about using the Planner Graph API to report details of plans in a Microsoft 365 tenant, we explained the basics of how to extract data about plans, tasks, and buckets to create a report using a PowerShell script. Now we take the lessons learned a step forward to illustrate the principle that with access to data, the possibility for creative use of that data is boundless and upgrade the script to include a listing of incomplete tasks and per-user analysis of incomplete tasks for each plan.

June 12, 2023
Keeping Teams Tidy Through Automation 2 Comments

Keeping Teams Tidy Through Automation

With a relatively small amount of effort, the provisioning of Teams in an organization can be automated to cater to the requirements of the business, as well as IT. In this article, Sean McAvinue goes over keep your Teams tidy through some useful tips and PowerShell code.

June 6, 2023
Practical Graph: Reporting Plans in a Microsoft 365 Tenant

Practical Graph: Reporting Plans in a Microsoft 365 Tenant

The arrival of application permissions for the Planner Graph API makes it much easier to write PowerShell scripts to automate administrative operations like reporting Planner data. This article describes a example script that uses the Planner APIs to gather and report information about the plans belonging to Microsoft 365 Groups.

May 30, 2023
Disabling PowerShell for Exchange Online Users 12 Comments

Disabling PowerShell for Exchange Online Users

Most Microsoft 365 user accounts don't need access to Exchange Online PowerShell. It's an administrative tool that end users don't get much value from. In this article, we explore the best way to disable Exchange Online PowerShell using a script that can run interactively or as a scheduled Azure Automation runbook (the best way for automatic management).

May 15, 2023
Practical Graph: Using the Extract Sensitivity Labels Graph API 13 Comments

Practical Graph: Using the Extract Sensitivity Labels Graph API

A Graph API is available to extract details of the sensitivity labels assigned to SharePoint Online documents. This article explores how to extract the information from files in a document library and use it to create a report. The nice thing is that once you have the data, you can slice and dice it any way you wish in Excel, Power BI, or whatever tool you prefer.

April 20, 2023
Building your Microsoft 365 PowerShell Toolbox 5 Comments

Building your Microsoft 365 PowerShell Toolbox

PowerShell is an important tool for any Microsoft 365 Admin – particularly in larger environments. In this article, Sean McAvinue outlines some key tools and concepts to help tenant admins build a ‘toolbox’ for PowerShell to make almost any scripting task easier and more robust.

April 6, 2023