blog.icewolf.ch

Let's talk about IT!
posts - 2080, comments - 295, trackbacks - 0

My Links

Archives

Post Categories

icewolf

Azure

Azure
Analyze Azure Active Directory Sign-in Location

Hi All, Azure Active Directory Sign-in Logs is really helpful, when analyzing Sign-in Problems. But it also can be very helpful, when analyzing the overall Sign-ins or looking out for strange behavior. One of the Tips would be th Filter for Location and use the CountryCode and Status of Sucess I have set up Azure Active Directory Diagnostics to save the Sign-In Logs to a LogAnalytics Workspace. Here you can Query the Logs with KQL. Let's search for Logins that come from Outside Switzerland. SigninLogs | where TimeGenerated > ago(30d) | where LocationDetails.countryOrRegion <> "CH" //| where Status.errorCode <> "0" //Not Sucessful Logins | project UserPrincipalName, Status.errorCode, Status.failureReason,AppDisplayName, ResourceDisplayName, LocationDetails.countryOrRegion It's...

posted @ Thursday, May 26, 2022 8:12 AM | Filed Under [ Security Azure ]

Azure File Sync Agent 15.0 has been released

Hi All, I had almost forgotten, that on the Microsoft Patchday also a new Version of Azure FileSyncAgent was available. When i look at the Azure Storage Sync Service i see that the Registered Server runs FileSyncAgent 14.1 Azure File Sync Agent v15.0 https://www.microsoft.com/en-us/download/details.aspx?id=57159 I've downloaded the MSI but was not able to install, without uninstalling the Software first Instead i used the Windows Update Package After a Reboot i can see the new Azure File Sync Agent Version in Azure Portal Regards Andres Bohren

posted @ Tuesday, May 24, 2022 9:35 PM | Filed Under [ Azure ]

Azure PowerShell Module Az 8.0.0 released

Hi All, A few Hours ago, Microsoft has released the Azure PowerShell Module AZ v8.0.0 Microsoft Azure PowerShell AZ 8.0.0 https://www.powershellgallery.com/packages/AZ/8.0.0 Release Notes not yet udated https://docs.microsoft.com/en-us/powershell/azure/release-notes-azureps?view=azps-7.5.0 Check your current installed Module and what is available on PowerShell Gallery Get-InstalledModule AZ Find-Module AZ I've published a Script in my GitHub Repo to uninstall the old Modules and install the new Modules https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/AzureAD/Microsoft.Graph_HowToStart.ps1 Or you can run the Script below to directly execute that Script #Run Script directly from GitHub $ScriptFromGitHub = Invoke-WebRequest "https://raw.githubusercontent.com/BohrenAn/GitHub_PowerShellScripts/main/Azure/Cleanup-AZModules.ps1" Invoke-Expression $($ScriptFromGitHub.Content) Check the Modules Get-InstalledModule AZ Get-InstalledModule AZ.* Regards Andres Bohren

posted @ Tuesday, May 24, 2022 11:51 AM | Filed Under [ PowerShell Azure ]

Update Modules on Azure Automation with AZ PowerShell

Hi All, As you probably know, i am a big Fan of Azure Automation to run some Automation Scripts for M365 in Azure. When you try to install a new Microsoft Graph Module in Azure Automation from the Gallery it will fail, due its dependency for Microsoft.Graph.Authentication, because an older Version is installed. I've tried to figure out, how to update the Modules with PowerShell (too much clicking for doing it manually). By the way it's worth mentioning, that you only see the PowerShell 5.1 Modules. Anyone knows how to display the PowerShell 7 Modules? Connect-AzAccount $AutomationAccount = Get-AzAutomationAccount -Name icewolfautomation -ResourceGroup RG_DEV $AutomationModules[0] $AutomationModules | where {$_.Name...

posted @ Tuesday, May 24, 2022 9:11 AM | Filed Under [ PowerShell Azure ]

Azure PowerShell Module Az 7.5.0 released

Hi All, Yesterday the AZ PowerShell Module 7.5.0 has been released AZ PowerShell Module 7.5.0 https://www.powershellgallery.com/packages/az/7.5.0 I have used my Cleanup-AZModules.psy from my GitHub Repo to update the Modules https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Cleanup-AZModules.ps1 Get-InstalledModule AZ Get-InstalledModule AZ.* Regards Andres Bohren

posted @ Wednesday, April 27, 2022 8:15 AM | Filed Under [ PowerShell Azure ]

MSIdentityTools PowerShell Module v2.0.10 released

Hi All, Today Microsoft has released a new Version of the MSIdentityTools PowerShell Module MSIdentityTools 2.0.10 https://www.powershellgallery.com/packages/MSIdentityTools/2.0.10 Find-Module MSIdentityTools If you have already installed a Version of the PowerShell Module Uninstall-Module MSIdentityTools Install the PowerShell Module Install-Module MSIdentityTools Get-Command -Module MSIdentityTools Get-MsIdAzureIpRange | measure Connect-MgGraph Resolve-MsIdTenant -TenantValue icewolfch.onmicrosoft.com Regards Andres Bohren

posted @ Thursday, April 21, 2022 10:08 PM | Filed Under [ Azure ]

M365 group-based License (step-by-step)

Hi All, Most Organizations i know use M365 group-based Licensing. It fit's theyr provisioning Processes because it's just adding a User to another Active Directory Group. As they are already used to do. What is group-based licensing in Azure Active Directory? https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-licensing-whatis-azure-portal Licensing requirements You must have one of the following licenses for every user who benefits from group-based licensing: Paid or trial subscription for Azure AD Premium P1 and above Paid or trial edition of Microsoft 365 Business Premium or Office 365 Enterprise E3 or Office 365 A3 or Office 365 GCC G3 or Office 365 E3 for GCCH...

posted @ Saturday, April 9, 2022 4:37 PM | Filed Under [ Azure ]

Deploy Azure SQL Database with ARM Template (Part 3)

Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with an ARM Template. First i started creating a SQL Database in the Azure Portal. Under "Review + create" you can download the Template. The Template consists of a template.json and parameters.json This Script is also available on my GitHub Repo https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Demo03-SQLDB-ARM.ps1 ############################################################################### # Demo03-SQLDB-ARM.ps1 # Create SQL Server / Firewall Rule / SQL Database with ARM Template (JSON) # 05.04.2022 - Initial Version - Andres Bohren ############################################################################### ############################################################################### # Connect AzAccount ############################################################################### Connect-AzAccount ############################################################################### #...

posted @ Wednesday, April 6, 2022 10:30 PM | Filed Under [ Azure ]

Deploy Azure SQL Database with AZ CLI (Part 2)

Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with the AZ CLI https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-windows?tabs=azure-cli The Script can also be found on my GitHub Repo https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Demo02-SQLDB-AzCli.ps1 ############################################################################### # Demo02-SQLDB-Az.ps1 # Create SQL Server / Firewall Rule / SQL Database with AZ CLI # 05.04.2022 - Initial Version - Andres Bohren ############################################################################### ############################################################################### # Login with AzureCLI ############################################################################### az login ############################################################################### # Create Demo Resource Group # https://docs.microsoft.com/en-us/cli/azure/group?view=azure-cli-latest#az-group-create ############################################################################### $ResourceGroup = "RG_Demo02" $Location = "westeurope" az group create --location $Location --name $ResourceGroup ############################################################################### # Create SQL Server Object # https://docs.microsoft.com/en-us/cli/azure/sql/server?view=azure-cli-latest#az-sql-server-create ############################################################################### $SQLServerName = "icewolfsqldemo02" $AdminUser = "sqladmin" $AdminPassword =...

posted @ Wednesday, April 6, 2022 10:59 AM | Filed Under [ Azure ]

Deploy Azure SQL Database with AZ PowerShell Module (Part 1)

Hi All, Finally i have some time to do a Project i've always wanted to do. In a Series of Blog Article i will create a SQL Server / SQL Database in Azure and compare diffrent Deployment Methods. Let's start with the PowerShell AZ Module Install-Module AZ The Script can also be found on my GitHub Repo https://github.com/BohrenAn/GitHub_PowerShellScripts/blob/main/Azure/Demo01-SQLDB-Az.ps1 ############################################################################### # Demo01-SQLDB-Az.ps1 # Create SQL Server / Firewall Rule / SQL Database with AZ.* Powershell Modules # 05.04.2022 - Initial Version - Andres Bohren ############################################################################### ############################################################################### # Connect AzAccount ############################################################################### Connect-AzAccount ############################################################################### # Set Subscription ############################################################################### Set-AzContext [SubscriptionID/SubscriptionName] ############################################################################### # Create Resource Group # https://docs.microsoft.com/en-us/powershell/module/az.resources/new-azresourcegroup?view=azps-7.4.0 ############################################################################### $ResourceGroup = "RG_Demo01" $Location = "westeurope" New-AzResourceGroup -Name $ResourceGroup -Location $Location ############################################################################### # Create SQL Server Object # https://docs.microsoft.com/en-us/powershell/module/az.sql/new-azsqlserver?view=azps-7.3.2 ############################################################################### $Credential = Get-Credential $SQLServerName = "icewolfsqldemo01" $MinimalTLSVersion...

posted @ Wednesday, April 6, 2022 10:47 AM | Filed Under [ Azure ]

Full Azure Archive

Powered by:
Powered By Subtext Powered By ASP.NET