Report Azure AD user IDs last logon timestamp using Microsoft Graph API

December 8, 2020November 17, 2021 / Hugo Gungormez

It's been a while since I've updated my blog so here we go! This is a step-instruction guide on how to generate Azure AD reports listing all users' last logon time. This is particularly handy as is not possible to generate any such report using AzureAD or AzureADPreview PowerShell modules. Prerequisites Azure Active DirectoryWeb browserMicrosoft … Continue reading Report Azure AD user IDs last logon timestamp using Microsoft Graph API

Azure ExpressRoute Utilisation – Automate EOM Reporting with Log Analytics & Logic Apps

March 5, 2020November 17, 2021 / Hugo Gungormez

We can generate ExpressRoute link utilisation within Azure by leveraging log analytics, logic apps and email! Very beneficial for automating end of month reporting. Pre-requisites Azure subscription. Log analytics workspace (per GB if you require reporting more than 7 days). ExpressRoute link. ExpressRoute network monitor SPN SMTP Relay KQL KQL stands for Kusto-Query … Continue reading Azure ExpressRoute Utilisation – Automate EOM Reporting with Log Analytics & Logic Apps

Terraform Variables

August 8, 2019November 17, 2021 / Hugo Gungormez

Similar to all other programming languages, Terraform also makes use of variables for dynamic coding. You can have a dedicated Terraform variables file with extension .TFVARS within your working directory/folder and this will automatically be referenced in your main Terraform code file, so you can call directly and/or interpolate. There are several different types of … Continue reading Terraform Variables

How to create an Azure SPN for Terraform

August 5, 2019November 17, 2021 / Hugo Gungormez

Service Principal Name is effectively a service account within Azure. Required in this scenario for our Terraform Provider function to connect our TF code to our Azure Subscription. Login to https://portal.azure.com. Click into Azure Active Directory. Click App Registrations >+ New registration. Provide a name for your SPN ie. terraform-spn, provide any valid URL within … Continue reading How to create an Azure SPN for Terraform

Connecting PowerShell to Azure (Office 365)

November 20, 2015November 17, 2021 / Hugo Gungormez

First install the Microsoft Online Services Sign-In Assistant for IT Professionals RTW from the Microsoft Download Center. Then install the Azure Active Directory Module for Windows PowerShell (64-bit version), and click Run to run the installer package. Before you can run any of the cmdlets discussed in this article, you must first connect to your … Continue reading Connecting PowerShell to Azure (Office 365)