Set VM Cloud and User Role with VMM PowerShell

When you install Azure Pack you need to add a cloud and userole on each VM.
Manually this is a boring click job..

PowerShell makes this a lot easier, first change the cloud and then the user role:

Import-Module virtualmachinemanager

$VMs = Get-VM | where { $_.Name -Match 'SQL' }

$SSRole = Get-SCUserRole -Name "USERROLE"

$VMs | foreach Name | set-scvirtualmachine -Owner "OWNER" -UserRole $SSRole

Import-Module virtualmachinemanager

$VMs = Get-VM | where { $_.Name -Match 'SQL' }

$Cloud = get-sccloud -Name "NAME"

$VMs | foreach Name | set-scvirtualmachine -Cloud $Cloud