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
Cloud
Connect to AWS CLI via Powershell
In this tutorial, you can connect your Powershell terminal to AWS CLI using SAML2AWS. Especially handy for AWS tenancies utilising MFA authentication. Pre-requisites Powershell 5.1 Chocolatey SAML2AWS Instructions Launch elevated Powershell. Execute CMDLET Set-ExecutionPolicy Bypass -Scope Process. Download and save Chocolatey installation script. Install Chocolatey by executing installation script using CMDLET .\install.ps1. Wait for it … Continue reading Connect to AWS CLI via Powershell
Azure ExpressRoute Utilisation – Automate EOM Reporting with Log Analytics & Logic Apps
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
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
Connecting PowerShell to Azure (Office 365)
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)
Kamikaze Admin 