Start-SAPSystem.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 |
<#PSScriptInfo .DESCRIPTION Azure Automation Runbook Script to start an SAP system. .VERSION 0.0.5 .GUID d1b72758-4395-4316-bebd-905fe3319ffe .AUTHOR Goran Condric .COMPANYNAME Microsoft .COPYRIGHT (c) 2020 Microsoft . All rights reserved. .TAGS Azure Automation SAP System Start Runbook .LICENSEURI .PROJECTURI .ICONURI .EXTERNALMODULEDEPENDENCIES SAPAzurePowerShellModules .REQUIREDSCRIPTS .EXTERNALSCRIPTDEPENDENCIES .RELEASENOTES 0.0.1: - Add initial version 0.0.3: - Add dedpendencies to SAPAzurePowerShellModules module 0.0.4: - Add functionality for Java systems 0.0.5: - Support for using a system-assigned managed identity for an Azure Automation account, and multiple Azure subscriptions #> #Requires -Module SAPAzurePowerShellModules Param( [Parameter(Mandatory=$True, HelpMessage="SAP System <SID>. 3 characters , starts with letter.")] [ValidateLength(3,3)] [string] $SAPSID, [Parameter(Mandatory=$False)] [int] $WaitForStartTimeInSeconds = "600", [Parameter(Mandatory=$False)] [bool] $ConvertDisksToPremium = $False, [Parameter(Mandatory=$False)] [bool] $PrintExecutionCommand = $False, [Parameter(Mandatory=$false, HelpMessage="Subscription ID. If null, the current subscription of automation account is used instead.")] [ValidateLength(36,36)] [string] $SubscriptionId ) Write-WithTime "Make sure to enable appropriate RBAC permissions to the system identity of this automation account. Otherwise, the runbook may fail." Write-Output "" Write-Output "You can enable system identity on the Azure automation account:" Write-Output "1. Go to: Azure automation acccount -> Identity -> System asigned -> Status -> <On>" Write-Output "2. Go to: Azure automation acccount -> Identity -> System asigned -> Permissions -> Azure role assignments -> Add role assignment ->" Write-Output "Scope: 'Subscription'" Write-Output "Subscription: <Chose your Subscription>" Write-Output "Role: 'Owner'" Write-Output "" Write-Output "More info on: https://docs.microsoft.com/en-us/azure/automation/enable-managed-identity-for-automation#assign-role-to-a-system-assigned-managed-identity " Write-Output "" # Connect to Azure with Automation Account system-assigned managed identity Write-WithTime " Connecting to Azure with Automation Account system-assigned managed identity ...." Write-Output "" # Ensures you do not inherit an AzContext in your runbook Disable-AzContextAutosave -Scope Process | out-null try { # Connect to Azure with system-assigned managed identity $AzureContext = (Connect-AzAccount -Identity).context } catch{ Write-Error "There is no system-assigned user identity. Aborting."; Write-Error $_.Exception.Message exit } if ($SubscriptionId){ Write-Output "Using specified Subscription ID '$SubscriptionId'." $SubscriptionId = $SubscriptionId.trim() Select-AzSubscription -SubscriptionId $SubscriptionId -ErrorVariable -notPresent -ErrorAction SilentlyContinue -Tenant $AzureContext.Tenant } # set and store context $AzureContext = Set-AzContext -SubscriptionName $AzureContext.Subscription -DefaultProfile $AzureContext # get start time $StartTime = Get-Date $SAPSID = $SAPSID.Trim() #Test if Tag 'SAPSystemSID' with value $SAPSID exist. If not exit Test-AzSAPSIDTagExist -SAPSID $SAPSID # Get SAP Appplication VMs $SAPSIDApplicationVMs = Get-AzSAPApplicationInstances -SAPSID $SAPSID # List SAP Application layer VM Write-Output "" Write-WithTime "SAP Application layer VMs:" Show-AzSAPSIDVMApplicationInstances -SAPVMs $SAPSIDApplicationVMs # Get DBMS VMs $SAPSIDDBMSVMs = Get-AzSAPDBMSInstances -SAPSID $SAPSID # List SAP DBMS layer VM(s) Write-Output "" Write-WithTime "SAP DBMS layer VM(s):" Show-AzSAPSIDVMDBMSInstances -SAPVMs $SAPSIDDBMSVMs #################################### # Convert the disks to Premium_LRS #################################### if($ConvertDisksToPremium){ Convert-AzALLSAPSystemVMsCollectionManagedDisksToPremium -SAPSIDApplicationVMs $SAPSIDApplicationVMs -SAPSIDDBMSVMs $SAPSIDDBMSVMs } ################### # Start VMs ################### Write-WithTime "Starting VM(s) ..." # Start ABAP ASCS VMs Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDApplicationVMs -SAPInstanceType "SAP_ASCS" # Start Java SCS VMs Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDApplicationVMs -SAPInstanceType "SAP_SCS" # Start ABAP SAP_DVEBMGS VM Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDApplicationVMs -SAPInstanceType "SAP_DVEBMGS" # Start DBMS VMs Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDDBMSVMs -SAPInstanceType "SAP_DBMS" # Start ABAP Dialog Instances (Application Servers) VMs Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDApplicationVMs -SAPInstanceType "SAP_D" # Start Java Application Server Instances VMs Write-Output "" Start-AzVMTagAndCheckVMStatus -SAPVMs $SAPSIDApplicationVMs -SAPInstanceType "SAP_J" ################### # Start DBMS ################### # Get DBMS Type $DatabaseType = $SAPSIDDBMSVMs.DBMSType # get DBMS Status Write-Output "" Get-AzDBMSStatus -SAPSIDDBMSVMs $SAPSIDDBMSVMs -PrintExecutionCommand $PrintExecutionCommand # Start DBMS Write-Output "" Start-AzDBMS -SAPSIDDBMSVMs $SAPSIDDBMSVMs -PrintExecutionCommand $PrintExecutionCommand # get DBMS Status Write-Output "" Get-AzDBMSStatus -SAPSIDDBMSVMs $SAPSIDDBMSVMs -PrintExecutionCommand $PrintExecutionCommand ################### # Start SAP ################### # Get SAP System Status Write-Output "" Get-AzSAPSystemStatus -SAPSIDApplicationVMs $SAPSIDApplicationVMs -PrintExecutionCommand $PrintExecutionCommand # Start SAP system Write-Output "" Start-AzSAPSystem -SAPSIDApplicationVMs $SAPSIDApplicationVMs -WaitForStartTimeInSeconds $WaitForStartTimeInSeconds -PrintExecutionCommand $PrintExecutionCommand # Get SAP System Status Write-Output "" Get-AzSAPSystemStatus -SAPSIDApplicationVMs $SAPSIDApplicationVMs -PrintExecutionCommand $PrintExecutionCommand # get end time $EndTime = Get-Date $ElapsedTime = $EndTime - $StartTime# ################### # SUMMARY ################### Write-Output "" Write-Output "Job succesfully finished." Write-Output "" Write-Output "SUMMARY:" If($ConvertDisksToPremium){ Write-Output " - All disks set to 'Premium_LRS' type." }else{ Write-Output " - All disks types are NOT changed." } Write-Output " - Virtual machine(s) are started." Write-Output " - DBMS started." Write-Output " - SAP system '$SAPSID' started." Write-Output "" Write-Output "[INFO] Total time : $($ElapsedTime.Days) days, $($ElapsedTime.Hours) hours, $($ElapsedTime.Minutes) minutes, $($ElapsedTime.Seconds) seconds, $($ElapsedTime.Seconds) milliseconds." |