Execute Azure Data Factory pipeline

Hi! Today I have for you script which can help you with execute Azure Data Factory pipeline. For those who never used Azure Data Factory – it’s Azure’s cloud ETL service for scale-out serverless data integration and data transformation. It’s very useful in scenarios when we want to automate a lot of things using different Azure data services. One of the main feature of this service is pipeline. It’s a …

Enable backup for all Azure VMs in your subscription

Hey Folks! Today I’ve got for you script which will enable backup for all Azure VMs in your subscription. All admins which setup IaaS environment in cloud, doesn’t matter if this is Azure or Amazon must remember that data from virtual machines should be configured to restore them in any time. In Azure there is a separate service to manage all backups of virtual machines called Recovery Service Vault. You …

lastlogondate

PowerShell Tip of the Week: Get duplicated AD groups

In this post, I want to share a simple method to find duplicated Active Directory objects. Get-ADGroup Recently I was looking for duplicated groups. I was using one of the ActiveDirectory module commands and a simple filter to find all groups. The Get-ADGroup cmdlet gets a group or performs a search to retrieve multiple groups from an Active Directory. The Identity parameter specifies the Active Directory group to get. You can identify a group …

Connect-MsolService

Identify Objects with DirSyncProvisioningErrors using PowerShell

Find out how to identify objects that have DirSyncProvisioningErrors using PowerShell. Some time ago we added an article on how to Identify Azure AD provisioning errors. In this short post, I will share a simple script for creating a CSV report for such errors. Azure Active Directory To get errors we need to first connect to Azure Active Directory using Connect-MsolService and entering credentials for a tenant administrator. Credentials: Connection and …

Remote Shared Mailbox

Get Remote Shared Mailbox using LDAPFilter

Find out how to get Remote Shared Mailbox using LDAPFilter. In this short article, I wanted to share a PowerShell script for getting user objects where property msExchRecipientTypeDetails is a Remote Shared Mailbox. Recipient Type Values First, we need to find which property and value are for Remote Shared Mailboxes. There are three attributes that we can check: msExchRemoteRecipientType msExchRecipientDisplayType msExchRecipientTypeDetails In this case, we will focus on msExchRecipientTypeDetails attribute …

Configure Azure SQL Server firewall

Hi Scripters! Today want to show you how in easy way configure Azure SQL Server firewall for multiple IP addresses. Last time I was working on IaaS configuration to allow connections from virtual machines to Azure SQL Server and decided to share my code with you. Script which I prepared is configured in following way. In first step it gathers all of the virtual machines in subscription and prepare rule …

Add multiple NSGs to multiple subnets in Azure

Hey Scripters! Today quite easy script but very usefull to add multiple nsgs tu subnets in Azure. Script is using JSON structure to define NSGs (Network Security Groups) and subnets to which they should apply. In NSGs JSON we simply define only NSGs which will be used in next JSON. In nsgAssignment JSON we are providing name of the nsgs and provide as array list of subnets to which they …

Generate certificate and add it to Azure Virtual Machine

Hello scripting maniacs! Today post will show you how to generate certificate and add it to Azure virtual machine using PowerShell script. Last time I have a case to configure Azure Front Door service with virtual machines which will be set in the backend. However during setting up this service I found that on virtual machines certificate with proper names should be configured. I have an idea to create self …