Attempting to remove a server from the Resource Authorization Policies groups gives the following error “WMI Failure: Unable to update local resource group” After some investigation we found that two of the RDS Servers defined on the Remote Desktop Broker were showing as unavailable. In our case these servers were…
-
-
Azure Graph Explorer – List All VM’s and their Disk SKU’s
Maybe you want to review all your virtual machine disk types? Using Azure Graph Explorer you can run the following query. You’ll get and output like this
-
Azure Graph Explorer – List all Unused VNIC’s
This Azure Graph query will list all the VNIC’s in all subscriptions that aren’t connected to Virtual Machines, Network Security Group or Private EndPoints.
-
Azure – List all Resource in a subscription.
Here’s a quick script, it loop through the subscriptions matching the -like String, it will then get give all the resource group names, resource names and types, this then output to a .csv file.
-
Saving Mail Attachments to Azure Blob Storage using Logic App
I recently had a requirement to Save Mail Attachments to an Azure Blob. The easiest way for me was to use a Logic App. Before starting create an Azure Storage Account, create the Blob and the required folder structure. Once complete you can start to design the Logic App. 1.…
-
Shutdown and Startup Azure VM’s based on Tags
Like many people we want to shutdown Azure VM’s when they are not being used, however with different time zones and working schedules this can vary. The obvious way is to shutdown VM’s based on Tags. Jobs can be scheduled through the Automation Account or via a Logic App if…
-
Search Azure Blob for File
Unfortunately the Azure Storage Explorer or Azure Portal doesn’t allow you to search for a filename stored on a blob, so a simple way to is to run PowerShell script to return the results and paths. This example outputs to a .csv Hope that helps!
-
Changing Azure SQL Firewall using Runbook
This Runbook will Add/Modify the Firewall Rules on an Azure SQL Server. This can be run interactively by removing the AzureRunAsConnection section. Additional it can be configured to run using Params (post to follow later)
-
PowerShell – Adding users and groups to a server using a CSV source
Quick and simple on here. This script takes the list of servers from a CSV file and then adds the specified user or groups to the local group of that server. CSV File should be formatted as follows “Name”“Server1”“Server2” A copy is attached if you want to download it.
-
Retaining the same IP address in Azure Site Recovery
Let’s say you need to retain your hardcoded IP Address when you migrate VMWare VM’s to Azure using Azure Site Recovery, in this case I want to my server to retain it’s IP Address of 10.0.198.203 Here’s how you complete this. Login to the Azure Portal Open your Site Recovery…