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…
-
Install WordPress on Ubuntu 18.04.1 AWS instance.
Nothing particularly difficult here, I just decided to put it all together in one place. This is for Ubuntu 18.04.1 on AWS. Once you’re connected via SSH to your AWS instance just follow these steps. Run Updates sudo apt-get update sudo apt-get upgrade Install Apache sudo apt install apache2 Install…
-
Finding all VM’s with an ISO mounted using PowerCLI.
If you ever need to find which of your VM’s have an ISO mounted here’s a quick PowerCLI command you can run. Get-VM | FT Name, @{Label=”ISO file”; Expression = { ($_ | Get-CDDrive).ISOPath }}
-
Changing a User’s Username in Office 365 with On-Prem AD
Many people are running Exchange Online and Office 365 running with Synced usernames and password from the On-Premise Active Directory, it works well most of the time but we discovered a problem when we had to rename a user, although they were renamed in our AD and the 0365 Portal…
-
Creating an SQL Cluster on VMWare
I’ve been working on a SQL cluster for a few weeks now and thought I’d share the build process for anyone that wants to do the same. Configuration Differs depending on Single or Multi-host Single Host – Multinode Creating the First Cluster node virtual machine. Creating the Second cluster node…