How can we help you today? How can we help you today?

Extract agent info from the clone object

Roll out is going well. I am now looking to ways to effectively cycle images. We agreed with a dev team on a predictable refresh schedule.

I'm trying to get the MachineName and Environement from the clone object using the commandlet. I can't get to figure out the best way to go. I find no hang from the clone object to its sql clone env.

The reason being : After dropping all old images (and their clones), I need to re-create new clones with a newer DB image. Ideally, the process would be fully automated and transparent to the dev teams.

Thanks in advanced for your help
Regard
David
Benethor
0

Comments

2 comments

Sort by
  • ErdoganOzkoca
    Hi Benethor,

    You can use the below script to get the machine name and environment from a clone.

    Connect-SqlClone -ServerUrl 'http://your_sql_clone_domain:14145'
    $clone = Get-SqlClone -Name your_clone_name
    $locationId = $clone.LocationId
    $sqlServerInstance = Get-SqlCloneSqlServerInstance | where {$_.Id -eq $clone.LocationId}
    $sqlServerInstance.Machine
    ErdoganOzkoca
    0
  • Benethor
    Thank you very much for your help.
    Benethor
    0

Add comment

Please sign in to leave a comment.