Get-MgmtSvcSqlHostingServer
Gets a SQL Server hosting server.
Syntax
Get-MgmtSvcSqlHostingServer
[[-Name] <String>]
[-Skip <Int32>]
[-First <Int32>]
[-Descending]
[-AdminUri] <Uri>
[-Token] <String>
[-DisableCertificateValidation]
[<CommonParameters>] Description
The Get-MgmtSvcSqlHostingServer cmdlet gets a SQL Server hosting server. By default, all hosting servers are returned. To get a specific hosting server, use the Name parameter. You can also get a specified number of servers by using the First and Skip parameters.
Examples
Example 1: Get a specific SQL hosting server by name
PS C:\> Get-MgmtSvcSqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "SQLServer01.Contoso.com"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 hosting server named SQLServer01.Contoso.com.
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 |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Descending
Indicates that the returned servers are displayed in descending order.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| 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.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-First
{{Fill First Description}}
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Name
Specifies the name of a SQL Server hosting server.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Skip
{{Fill Skip Description}}
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| 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 |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Inputs
None
Outputs
SqlHostingServer
This cmdlet emits a SqlHostingServer object.