Get-MgmtSvcSqlServerGroup

Get-MgmtSvcSqlServerGroup

Gets a SQL Server group.

Syntax

Parameter Set: Default
Get-MgmtSvcSqlServerGroup [-AdminUri] <Uri> [-Token] <String> [[-GroupName] <String[]> ] [-DisableCertificateValidation] [ <CommonParameters>]

Detailed Description

The Get-MgmtSvcSqlServerGroup cmdlet gets SQL Server groups. By default, all SQL Server groups are returned. To get a specific server group, use the GroupName parameter.

Parameters

-AdminUri<Uri>

Specifies the URI of the Windows Azure Pack administrator API. Use the following format: https://<computer>:<port>, where <computer> is the computer on which the administrator API is installed.

Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation. If you specify this parameter, you can use self-signed certificates.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-GroupName<String[]>

Specifies an array of SQL Server group names.

Aliases

none

Required?

false

Position?

4

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-Token<String>

Specifies an identity token. To create a token, use the Get-MgmtSvcToken cmdlet.

Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None

Outputs

The output type is the type of the objects that the cmdlet emits.

  • SqlServerGroup

    This cmdlet emits a SqlServerGroup object.

Examples

Example 1: Get a specific SQL server group

NOTE: This example assumes that you have created a token by using Get-MgmtSvcToken and have stored it in a variable named $Token.

This command gets the SQL Server group named SQL Group 01.

PS C:\> Get-MgmtSvcSqlServerGroup -AdminUri "https://Computer01:30004" -Token $Token -GroupName "SQL Group 01"

Add-MgmtSvcSqlServerGroup

Remove-MgmtSvcSqlServerGroup