Authenticate against Exchange Online in Azure Automation securely and easy with a certificate

When using Azure Automation one of the big questions have always been, what do we do about Runbooks that needs access to Exchange Online PowerShell? If you were reckless security wise you could always have an admin account with basic auth and no MFA. The second best thing, but a hassle, is to setup a … Continue reading Authenticate against Exchange Online in Azure Automation securely and easy with a certificate

Fewer emails after deploying Microsoft Teams?

Many organizations send files and have long conversations on email internally. What will happen to the number of emails sent internally after the deployment of Microsoft Teams? I have created a verry simple script/method to automatically gather/messaure this by. You should set it up as soon as you are in the pre-planning of a Teams … Continue reading Fewer emails after deploying Microsoft Teams?

Wouldn’t it be cool to get that report through PowerShell/Graph API?

In the Microsoft Teams admin portal you have several interesting reports. You can run the reports and download as a csv. Then after import downloading, you could import the csv into PowerShell to play with the data. Wouldnt it be better to get these data directly into PowerShell? What if you want only a portion … Continue reading Wouldn’t it be cool to get that report through PowerShell/Graph API?

Consolidate Teams and SharePoint activity reports!

Want an easy way to see Teams and SharePoint usage data in the same report? Then you have come to the right place. This will be a halfway automatic process, as you need to manually download two reports from the Teams and SharePoint admin portals. It is possible to get most of the SharePoint data … Continue reading Consolidate Teams and SharePoint activity reports!

Disable and revoke Azure AD tokens from expired AD users

If you have an environment on-premises and are starting to take advantage of the cloud, then there's a lot to be aware of. One big thing to take notice of is that Azure AD does not respect user expired state in AD. When logging on to Office 365 services outside of ADFS with CloudNative Auth, … Continue reading Disable and revoke Azure AD tokens from expired AD users

I spy with my little eye a Graph API PowerShell SDK!

So recently I spotted a repository on GitHub called msgraph-sdk-powershell. It turns out that Microsoft has started working on a PowerShell SDK for the Graph API. You can find it over here. So what is this all about? For me, this makes total sense as it would simplify the process of doing Graph requests in … Continue reading I spy with my little eye a Graph API PowerShell SDK!