SQL Server PowerShell

Microsoft.SQLServer.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell (ConsoleTask)

Open SQLPS console and connect to target Availability Replica.

Element properties:

Source Code:

<ConsoleTask ID="Microsoft.SQLServer.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell" Accessibility="Internal" Target="SqlDiscW!Microsoft.SQLServer.Windows.AvailabilityReplica" RequireOutput="false">

  <Assembly>Res.Microsoft.SQLServer.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell</Assembly>

  <Handler>ShellHandler</Handler>

  <Parameters>

    <Argument Name="Application">powershell.exe</Argument>

    <Argument Name="WorkingDirectory"/>

    <Argument>-NoExit -NoLogo -NoProfile -Command Invoke-Command {

$IncludeFileContent/Scripts/PsTaskCommon.ps1$

            

$p = 0

$destInstanceNameParam = @'

$Target/Property[Type="System!System.Entity"]/DisplayName$

'@

$p = 0

$agNameParam = @'

$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityReplica"]/AvailabilityGroupName$

'@

$p = 0

$arNameParam = @'

$Target/Property[Type="System!System.Entity"]/DisplayName$

'@



$destInstanceName = GetInstancePathName $destInstanceNameParam

$agPathName = EncodeSqlName $agNameParam

$arPathName = EncodeSqlName $arNameParam



cd ('sqlserver:\SQL\{0}\AvailabilityGroups\{1}\AvailabilityReplicas\{2}\' -f $destInstanceName, $agPathName, $arPathName)

            }</Argument>

  </Parameters>

</ConsoleTask>