Powershell query to get Availability Group Name

• jellis 48252

  Old Hand

  Points: 315

  More actions

  March 12, 2013 at 5:03 pm

  #269777

  Hi,

  I am building a powershell script that has a GUI interface for a 2008R2 cluster with SQL 2012 AlwaysOn Availability Groups. I am at the last stage where I am trying to build out the script to force the manual failover to a third node at a remote site and I am having a difficult time via either powershell or T-SQL building a query that will return just the Availability Group name that I could use with the Switch-AvailabilityGroup command.

  Would someone have some insight on how I might accomplish this?

  Thank you.

• Nick_UK

  SSCommitted

  Points: 1909

  More actions

  March 28, 2013 at 10:58 am

  #1601753

  you could try using the below adding your server name into the variable

  $Server = "SERVERNAME"

  Set-Location SQLSERVER:\SQL\$Server\DEFAULT\AvailabilityGroups(get-childitem).Name

• jellis 48252

  Old Hand

  Points: 315

  More actions

  March 28, 2013 at 2:37 pm

  #1601866

  Thank you. I will give this a try.