Get-MgmtSvcSqlHostingServerByGroup

Gets hosting servers by SQL Server group.

Syntax

Get-MgmtSvcSqlHostingServerByGroup
   [-ServerGroupId] <String>
   [[-Name] <String[]>]
   [-AdminUri] <Uri>
   [-Token] <String>
   [-DisableCertificateValidation]
   [<CommonParameters>]

Description

The Get-MgmtSvcSqlHostingServerByGroup cmdlet gets SQL Server hosting servers by SQL Server group. By default, all SQL Server hosting servers for a group are returned. To get a specific hosting server, use the Name parameter.

Examples

Example 1: Get all SQL hosting servers for a group

PS C:\> Get-MgmtSvcSqlHostingServerByGroup -AdminUri "https://Computer01:30004" -Token $Token -ServerGroupId "g5sho0"

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 all SQL Server hosting servers in the group with the ID of g5sho0.

Required Parameters

-AdminUri

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.

Type:Uri
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ServerGroupId

Specifies the ID of a SQL Server group.

Type:String
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Token

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

Type:String
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation.

If you specify this parameter, you can use self-signed certificates.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Name

Specifies an array of SQL Server hosting server names.

Type:String[]
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Inputs

None

Outputs

SqlHostingServerList

This cmdlet emits a SqlHostingServerList object.