Author Archives: jmattmacd

Applying Intune tags with a Function App

By | October 26, 2020

Apply an Intune Scope Tag to a group of devices based on the device owner attributes. Please note this OVERWRITES current tags. In order to provide administrative isolation in Intune Microsoft use the concept of Tags. Tags apply to policies, app assignments, profiles and devices and an administrator with the appropriate role can only see… Read More »

Loading

Flow/Power Automate and Function Apps – Securing a Function App with a Service Principal

By | November 3, 2020

I’ve written a fair bit about how I use Function apps and Flow to get data about 365 environments. There are clear advantages and disadvantages of each. Flow is incredibly slow, difficult to process data in and is in general restricted to what you can take out of Microsoft Graph. Function Apps allow you to… Read More »

Loading

Function Apps using Passwords – KeyVaults!

By | September 18, 2020

This will allow you to securely stick a password or any other secret in a Key Vault for usage in a PowerShell function app (or anything else). You can of course stick the password or whatever directly in the app settings or even an (encrypted) file in your function app but this way has four… Read More »

Loading

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