Skip to content
Avater of Christian. Avatar is wearing a black and red checkered shirt that is open and a white t-shirt. Face has a light beared and a haircut that is short on the side and long on the top

christianfrohn.dk

  • Home
  • Microsoft 365Expand
    • Teams
    • Exchange
  • AzureExpand
    • App service
    • Storage account
    • SQL
  • Microsoft EntraExpand
    • Entra ID
    • Entra ID GovernanceExpand
      • Lifecycle Workflow
    • API-driven user provisioning
    • Service principal
  • PowerShell
  • About me
Github Linkedin
Avater of Christian. Avatar is wearing a black and red checkered shirt that is open and a white t-shirt. Face has a light beared and a haircut that is short on the side and long on the top
christianfrohn.dk
  • Microsoft Entra

    Using API-driven user provisioning with an Azure SQL database as a source of truth

    ByChristian Frohn May 15, 2024July 23, 2025

    Automating API-Driven User Provisioning with an Azure SQL Database. This post guides you through setting up an Azure SQL database and, integrating it with your HR system’s API, and then automating user creation and updates in Active Directory using API-driven provisioning to on-premises Active Directory

    Read More Using API-driven user provisioning with an Azure SQL database as a source of truthContinue

  • Microsoft Entra

    Configure EmployeeHireDate and EmployeeLeaveDateTime in Active Directory to be used with Microsoft Entra ID Governance.

    ByChristian Frohn May 2, 2024June 2, 2024

    To fully use Microsoft Entra ID Governance – more precisely lifecycle workflows -, you do need to configure a few things, although it is not mandatory to do it since all the lifecycle workflows can be run on-demand. But the whole purpose of lifecycle workflows is that they should run automatically based on attribute changes…

    Read More Configure EmployeeHireDate and EmployeeLeaveDateTime in Active Directory to be used with Microsoft Entra ID Governance.Continue

  • PowerShell

    Securely storing and retrieving credentials with Azure Key Vault in PowerShell scripts

    ByChristian Frohn April 30, 2024July 23, 2025

    When you are writing PowerShell scripts to automate various tasks in your everyday life in IT, the hardest part is often how to store the credentials to be used in your code in a secure way. In this blog post I want to show you how you can use an Azure Key Vault to store…

    Read More Securely storing and retrieving credentials with Azure Key Vault in PowerShell scriptsContinue

  • Microsoft Entra

    Securing Service Principals in Microsoft Entra ID with Conditional Access policies

    ByChristian Frohn April 22, 2024July 23, 2025

    Service Principals in your Microsoft cloud environment has long been a nice and convenient way to provide access to resources like SharePoint Online, Entra ID, Microsoft Graph or Azure resources by using a secret (password) or a certificate, and by then combining it with the client ID (username) for the Service Principles to be able…

    Read More Securing Service Principals in Microsoft Entra ID with Conditional Access policiesContinue

  • Microsoft Entra

    Modifying the attribute mapping in API-driven provisioning to on-premises Active Directory.

    ByChristian Frohn April 18, 2024June 4, 2024

    This blog post is a small continuation of the blog post about Getting started with API-driven Inbound User Provisioning to On-Premises AD, but in this blog, I’m going to show you how to modify the API and Active Directory mapping of attributes when you are provisioning users. This is useful if want to customize mapping…

    Read More Modifying the attribute mapping in API-driven provisioning to on-premises Active Directory.Continue

  • Microsoft Entra

    Getting started with API-driven Inbound User Provisioning to On-Premises AD

    ByChristian Frohn April 10, 2024July 23, 2025

    API-driven Inbound User Provisioning to On-Premises AD is a feature that I personally have been really excited about for quite some time. I started working with it when it was in public preview around June 2023 and it went to General Availability in early 2024.API-driven Inbound User Provisioning is streamlined way of managing users in…

    Read More Getting started with API-driven Inbound User Provisioning to On-Premises ADContinue

  • PowerShell

    Import SQL query from GitHub repository into a PowerShell script.

    ByChristian Frohn April 5, 2024April 5, 2024

    I want to emphasize that this blog post should ONLY be used with code that you are totally confident in, ideally your own code. This is something I have been wanting to achieve for some time now. Over the last couple of months, I have been working a on project with a colleague where I…

    Read More Import SQL query from GitHub repository into a PowerShell script.Continue

  • Teams

    Connect to Microsoft Teams PowerShell using Azure App reg. (Service principal) 

    ByChristian Frohn November 13, 2022June 22, 2024

    IntroNot long ago Microsoft finally release a new version for the Microsoft Teams PowerShell module (4.8.0) that adds the ability to authenticate to Microsoft Teams using a Azure App reg. Using a Azure App reg. Is in my opnion the most secure way to authenticate when you are running scheduled task (or simlar). So if you…

    Read More Connect to Microsoft Teams PowerShell using Azure App reg. (Service principal) Continue

  • Microsoft Entra

    Monitor Azure App registration secret / certificate expiry with PowerShell

    ByChristian Frohn September 24, 2022June 2, 2024

    I came across a need to know when a certificates and secrets are about to expire on Azure app registrations, but there was no native way for me do this, expect to just scroll down the application registration list and look for “Expirer soon”, and that didn’t really do it for me.So, I decided to…

    Read More Monitor Azure App registration secret / certificate expiry with PowerShellContinue

  • Teams

    What is InterpretedUserType in Microsoft Teams?

    ByChristian Frohn May 18, 2022June 22, 2024

    I decided to write this blog to help other people get a better understanding of what InterpretedUserType is. My first in encounter with InterpretedUserType was almost a year ago when I was troubleshooting why a user in my Teams environment couldn’t receive PSTN phone calls using Direct Routing even though the user was enabled for…

    Read More What is InterpretedUserType in Microsoft Teams?Continue

Page navigation

Previous PagePrevious 1 2 3 4 Next PageNext
GitHub Repositories Section

Entra

PowerShell scripts for Microsoft Entra ID administration and automation

Azure

Contains code related to Azure infrastructure deployment, automation and management

KQL

Contains KQL queries for Azure Monitor, Log Analytics and Sentinel

Most Viewed Posts

  1. Configure EmployeeHireDate and EmployeeLeaveDateTime in Active Directory to be used with Microsoft Entra ID Governance. (15,308)
  2. Securing Service Principals in Microsoft Entra ID with Conditional Access policies (14,378)
  3. Securely storing and retrieving credentials with Azure Key Vault in PowerShell scripts (11,994)
  4. Getting started with API-driven Inbound User Provisioning to On-Premises AD (10,306)
  5. Modifying the attribute mapping in API-driven provisioning to on-premises Active Directory. (10,234)

© 2025 christianfrohn.dk

  • Home
  • Microsoft 365
    • Teams
    • Exchange
  • Azure
    • App service
    • Storage account
    • SQL
  • Microsoft Entra
    • Entra ID
    • Entra ID Governance
      • Lifecycle Workflow
    • API-driven user provisioning
    • Service principal
  • PowerShell
  • About me
Search