How to get information about an AG group using powershell

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  December 7, 2019 at 10:41 am

  #3705648

  Hi Experts,

  Does anyone has a powershell script which displays below information:

  for a given AG listener name or AG group name, I need to get Listnener name, AG name, replicas , replica role desc ,

  Can we get this information using pure powershell which reads registry values or do we need to execute a sql DMV to get that information ?

  Thanks,

  Sam

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  December 8, 2019 at 11:10 am

  #3705735

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Tom Uellner

  SSCrazy

  Points: 2995

  More actions

  December 11, 2019 at 7:51 pm

  #3707131

  dbatools https://dbatools.io/has a whole group of PowerShell tools to get information about AG.