Category Archives: Office 365

Microsoft/Office 365 PowerShell in Azure Function Apps – Teams Module

By | September 17, 2020

This will build on my multiple posts building up a template function in a function app that allows scripted control and reporting on Microsoft 365. This will be the last part of my template app as once we have AAD, Exchange, Teams and Graph capabilities we are pretty much complete. In honesty the graph part… Read More »

Loading

Microsoft/Office 365 PowerShell in Azure Functions – AzureAD Module and Graph

By | May 10, 2021

I’m a big fan of running powershell in function apps. Sorry, no that’s wrong – I’m a big fan of NOT running powershell on “reporting servers”, “management boxes”, “that vm that does the 365 stuff” or anywhere where there is even the slightest chance I’m going to find myself fixing a problem on a windows… Read More »

Loading

Microsoft/Office 365 PowerShell in Azure Functions – Exchange Management

By | September 8, 2020

And on the seventh year of Exchange Online did the Version 2 PowerShell module be released and there was great rejoicing. Except for people trying to work in Azure Function Apps. Pretty much the most common reporting or regular maintenance activities in 365 is managing Exchange. We all have a tonne of powershell scripts for… Read More »

Loading

Setting up an AAD App Registration/Service Principal for Power Platform/Function Apps

By | February 17, 2021

Its just one of those things. Everything is great in your tenant all best practise, no creaky old servers anywhere then the phone rings and someone from the BI team says they need an hourly output of some stuff in csv and the columns have to be in a particular order. Or someone NEEDS a… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 4 – Summary and History

By | September 2, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanism for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 3 – Data Cleansing

By | August 18, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 2 – License Assignments

By | August 19, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 1 – Users

By | August 13, 2020

The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit was getting from that… Read More »

Loading

Microsoft/Office 365 PowerShell in Azure Functions – Setup an app and VS Code

By | August 1, 2020

You know that reporting server? Runs those PowerShell scripts to grab custom reports, add group prefixes and other general 365 maintenance tasks? Uses that global admin password that is exempt from MFA because it needs to run these scripts or uses a highly privileged ClientID/Secret? Means anyone that can get access to the drive with… Read More »

Loading