cmdlet : How to remove all clones for a specific machine (agent)

• 
  Hi Benethor, how about something like this?
  

  Connect-SqlClone -ServerUrl 'http://sql-clone.example.com:14145'
  
  $environmentName = $null # replace with environment name string if desired
  $machineName = 'myMachineName'
  
  $instancesOnMachine = Get-SqlCloneSqlServerInstance -MachineName $machineName | where {$_.Environment -eq $environmentName}
  
  foreach ($instance in $instancesOnMachine) {
      $clonesToDelete = Get-SqlClone -Location $instance
      foreach ($clone in $clonesToDelete) {
          Remove-SqlClone $clone | Wait-SqlCloneOperation
      }
  }
  

  
  This will find all SQL Server instances on a named machine, then find all clones based on those instances, and delete them.

  owen.hall October 16, 2017 10:48

  - 0 +
• 
  Nice! Does exactly what I need.
  
  Thanks a lot!

  Benethor October 16, 2017 12:17

  - 0 +
• 
  No problem - bear in mind I've spotted a bug in the case where $environmentName is null (intended to specify 'no environment'), in that if there are machines of the given name with an environment set, it'll delete clones from them as well. I'll fix that today and update the post.
  
  Edit: updated!

  owen.hall October 16, 2017 12:22

  - 0 +

Add comment

Please sign in to leave a comment.