Remoting in Azure Automation Runbooks (SQL DB Creation sample)

I find that using PowerShell remoting in my Azure automation runbooks is sometimes more convenient, as it eliminates the need to install and update additional PowerShell modules on my OMS hybrid runbook worker. For future reference, I wanted to capture an example of a simple approach to PowerShell remoting I find intuitive. The activities in this … Continue reading “Remoting in Azure Automation Runbooks (SQL DB Creation sample)”

Azure Automation Runbook to Add Computer to ConfigMgr Collection

Below for reference a quick PowerShell sample for adding a computer to a device collection in System Center Configuration Manager (ConfigMgr) via Azure Automation runook, designed for use on an OMS Hybrid Runbook Worker. It uses WMI, and so does not require the ConfigMgr PowerShell cmdlets. This also means it works for ConfigMgr 2012 and 2016. … Continue reading “Azure Automation Runbook to Add Computer to ConfigMgr Collection”

TIP: Keep your Azure Automation runbooks healthy across PowerShell module updates

Here’s a quick tip that may help you ensure you’re protect yourself from a problem that happens occasionally. Problem: I had a runbook that was broken when the PowerShell modules in the store were updated. Solution: What can you do to prevent this problem? One thing you can do to protect yourself against breaking changes in … Continue reading “TIP: Keep your Azure Automation runbooks healthy across PowerShell module updates”

Launch an OMS Automation Runbook on a Hybrid Worker from Orchestrator

While the Operations Management Suite (OMS) and Azure Automation are the future of process automation, there are still many customers still using System Center Orchestrator (SCO). In fact, when polling audiences I have spoken to in the last six months, they are still the majority. For customers taking their first step into hybrid cloud automation, … Continue reading “Launch an OMS Automation Runbook on a Hybrid Worker from Orchestrator”

5 TIPS FOR MODERNIZING YOUR PROCESS AUTOMATION STRATEGY

Don’t get me wrong, I love System Center Orchestrator (as you will see here AND here), but it is important to know when it is time to move on. Well my friends, it’s time. Some months ago now, Microsoft publicly announced that their investment in new features Orchestrator had come to an end, and that a cloud-first … Continue reading “5 TIPS FOR MODERNIZING YOUR PROCESS AUTOMATION STRATEGY”

Free E-book: Inside the Microsoft Operations Management Suite

Tao (@MrTaoYang), Stan (@StanZhelyazkov), Anders (http://contoso.se)  and I have been working on a project for the last few weeks. We wanted to bring a learning resource for the MS Operations Management Suite to the community that is complete, comprehensive, concise…and free (as in beer). While we finish final editing passes over the next couple of weeks, we … Continue reading “Free E-book: Inside the Microsoft Operations Management Suite”

Centralized Logging Strategy for Azure Automation Hybrid Worker with OMS

Many System Center Orchestrator administrators longed for centralized logging of Orchestrator runbook events and results. With no native centralized logging facility, many administrators used a simple SQL database as a centralized logging repository. While not ideal, this method is functional for a single data center. Think about the challenges of implementing this strategy on a … Continue reading “Centralized Logging Strategy for Azure Automation Hybrid Worker with OMS”

How to launch an Azure Automation runbook on a Hybrid Worker via PowerShell

With the update in Azure PowerShell 1.0, quite a lot has changed. Working with Azure has been divided into cmdlets for working with Azure 1.0 (Azure Service Management) and Azure 2.0 (Azure Resource Manager). With the GA release of the new Azure portal (https://portal.azure.com) that was called “the preview portal” forever, has arrived. In short, the PowerShell cmdlets for … Continue reading “How to launch an Azure Automation runbook on a Hybrid Worker via PowerShell”

How to Query Azure SQL Databases via PowerShell with SMO

In previous articles, I have demonstrated how to create Azure SQL Server and database instances via PowerShell in: How to Create an Azure SQL Instance via PowerShell How to Create an Azure SQL Database via PowerShell Certainly you could create both your Azure SQL Server instance and the database in the Azure Portal, so do … Continue reading “How to Query Azure SQL Databases via PowerShell with SMO”

Inside the MS Cloud Episode 5 – Azure IaaS v2 (resources and downloads)

In this episode, we do some show-and-tell with Azure Resource Manager, the next generation of template-based deployment for Microsoft Azure. If you are new to Azure IaaS v2, there is some how-to in this session you may find helpful. Software Resources The following are the software-related items mentioned in the show. PowerShell Tools for Visual … Continue reading “Inside the MS Cloud Episode 5 – Azure IaaS v2 (resources and downloads)”