Home
  •  

SQL Server PowerShell

Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroup (ConsoleTask)

Open SQLPS console and connect to Primary Replicas of target Availability Group.

Element properties:

TargetMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroup
Applicationsqlps.exe
WorkingDirectory
isRequireOutputFalse
AccessibilityInternal
EnabledTrue

Source Code:

<ConsoleTask ID="Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroup" Accessibility="Internal" Target="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup" RequireOutput="false" Category="MonitoringObject">

  <Application>sqlps.exe</Application>

  <Parameters>

    <Parameter>-NoExit</Parameter>

    <Parameter>"&amp;{ New-Variable -Name pr -Value '$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup"]/PrimaryReplicaServerName$'; function p{ param($v) if ($v -ilike '*\*') { return $v } else { return '{0}\DEFAULT' -f $v }  }; if (-Not [string]::IsNullOrEmpty($pr)) { $p = '{0}' -f (p($pr)); cd SQL\$p\AvailabilityGroups\; cd '$Target/Property[Type="System!System.Entity"]/DisplayName$\' -WarningAction SilentlyContinue; } else { Write-Host 'There is no primary replica for this Availability Group' }}"</Parameter>

  </Parameters>

  <WorkingDirectory/>

</ConsoleTask>