A site dedicated to Cloud and Datacenter Management

Book Review: Microsoft System Center Introduction to Microsoft Automation Solutions

Introduction to Microsoft Automation Solutions

Introduction to Microsoft Automation SolutionsRecently, I finished reading the Microsoft System Center Introduction to Microsoft Automation Solutions eBook.

The chapter(s) that I found most helpful were Chapter 2 “Understanding Automation: Architectures”, hence the majority of my highlights are from this chapters.

I’ve decided to share my highlights from reading this specific publication, in case the points that I found of note/interest will be of some benefit to someone else. So, here are my highlights (by chapter). Note that not every chapter will have highlights (depending on the content and the main focus of my work).


Chapter 01: Why Automation?


Chapter 02: Understanding Automation: Architectures

  • The recommended architecture for a Service Management Automation deployment includes the following:
    • A dedicated SQL server instance for the database role
    • Three servers co-hosting the web service and runbook worker roles
    • Load balancing of the web service role
    • Virtual machine deployment for ease of scaling and management
    • For hardware and software requirements, refer to the Service Management Automation TechNet article at
  • The database must run on Microsoft SQL Server 2012 at minimum and can be deployed to a standalone SQL Server server, a SQL Server failover cluster, or a SQL Server AlwaysOn Availability Group
  • It is worth noting the Service Management Automation database is a contained database, meaning it can be included in an availability group without the need to manually replicate additional objects.
  • The web service is essential for the operation of your Service Management Automation deployment; therefore, planning how it is deployed with scalability and resiliency in mind is critically important.
  • Consider the following when planning the deployment of the web service:
    • Use a generic DNS hostname for your web service URL, such as
    • Provision a web server certificate for your web service role using your generic DNS hostname. Be sure to mark the certificate’s private key as exportable so you can install it on additional web service role servers. As a general best practice with certificates, be sure to keep the certificate’s private key safe.
    • If you plan to use a third-party load balancer, use it to front your single server deployment initially so scaling out will not impact the service.
  • In the static job queue model, if a runbook worker becomes unavailable, any jobs destined for that server do not process until that server (or a new server with the same name) is brought online.
  • When you sign up for Microsoft Azure, you establish an Azure account that acts as a management and billing container. Within an Azure account, you can create and manage one or more Azure subscriptions, which can be used to separate administrator access or manage multiple lifecycles (e.g., development, test, and production).
  • A runbook that runs for more than 30 minutes will be suspended to allow other runbook jobs on the same runbook worker to process
  • The Azure Automation service billing model is based on runbook processing time in minutes


Chapter 03: Understanding Automation: Interfaces

  • For more details of URI syntax for the Service Management Automation web service, refer to
  • By default, the Service Management Automation web service is enabled for both Basic and Windows authentication
  • Whichever authentication method is used, the authenticating user must then be authorized to use the web service through membership in the smaAdminGroup local group on the web service servers.
  • The Service Management Automation Powershell module can be deployed on any system with Windows PowerShell version 4.0.


Chapter 04: Implementing Automation

  • Be aware that testing a runbook runs it live on a runbook worker server, so be sure to develop in a development environment before running your runbooks in production
  • For more details of using activities in script workflows, please refer to


Chapter 05: Managing Runbooks

  • Service Management Automation provides a built-in grooming process that relies on the SQL Server Agent to purge job history, and when this is enabled, the process will run every 15 minutes. By default, data older than 30 days is purged from the database.
  • If you require more detailed event log data, you can enable the Analytic log, which provides extensive logging information. However, enabling this log should be reserved for troubleshooting very complex issues.
  • It is always a best practice to replace a self-signed certificate with a certificate from an internal or external certificate authority that is trusted by your computers and services.
  • The web service and runbook worker roles of Service Management Automation both utilize a service account. The account used can be the same for both, but it is better for service accounts to leverage a separate account per role to help identify issues later.
  • During the installation of each role, the service account you provide is granted access to the Service Management Automation database with dbowner privileges and is granted the Logon as a Service right on the local server. Often, security policies override the Logon as a Service privilege by centrally managed configurations, so keep this in mind if your Service Management Automation system is not functioning.
  • During the installation of the web service role, a local group called smaAdminGroup is created on the server. This group is used to grant access accounts using the web service. By default, during the installation of the web service, only the service account specified during installation is added to the local group. Best practice is to place a group from your Active Directory domain in this local group and use the domain group for managing access to your Service Management Automation web service.


Chapter 06: Examples of Automation Scenarios

  • Because the Integration Module is known to Azure Automation, you do not need to explicitly import the runbook using the Import-Module cmdlet

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: