Share via


List the Servers by Group

 

Applies To: Windows Azure Pack

Retrieves a list of the hosting servers within the server group.

Request

Replace <ServiceMgmt> with your Service Management API endpoint address, and <GroupId> with the identifier of the server group.

Method

Request URI

HTTP version

GET

https://<ServiceMgmt>:30004/services/sqlservers/serverGroups/<GroupID>/hostingServers

HTTP/1.1

URI Parameters

None.

Request Headers

The following table describes required and optional request headers.

Request header

Description

Authorization: Bearer

Required. The authorization bearer token.

x-ms-principal-id

Required. The principal identifier.

x-ms-client-request-id

Optional. The client request identifier.

x-ms-client-session-id

Optional. The client session identifier.

x-ms-principal-liveid

Optional. The principal Live identifier.

Request Body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body.

Status Code

A successful operation returns status code 200 (OK).

Response Headers

The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response Body

The following table describes the key elements of the response body:

Element name

Description

HostingServer

The retrieved list of hosting servers. For more information, see HostingServer (Object).

Example

The following code example shows a List Hosting Servers By Group request.

GET https://<ServiceMgmt>:30004/services/sqlservers/serverGroups/<GroupID>/hostingServers HTTP/1.1
x-ms-version: 2012-03-01
Accept: application/json
Authorization: Bearer <Token>
x-ms-client-request-id: dd40b734-2377-40e9-8d51-b25c4c4377bb-2013-08-27 00:46:40Z
x-ms-client-session-id: d6272660-6ee3-45d5-8cb9-cc79a20799cc
x-ms-principal-id: <SERVICEMGMT>%5cAdministrator
Accept-Language: es-ES
Host: <ServiceMgmt>:30004

The following code example shows a List Hosting Servers By Group response.

[
  {
    "Name": ""<computer>",
    "ServerId": "djpf7",
    "Created": "0001-01-01T00:00:00+00:00",
    "AvailableSpaceMB": 20480,
    "TotalSpaceMB": 20480,
    "AvailabilityGroup": null,
    "DatabaseCount": 0,
    "State": 1,
    "ServerGroups": [
      {
        "GroupId": "2n9c",
        "GroupName": "Default",
        "AlwaysOnEnabled": false,
        "SharedFileServer": null,
        "HostingServerCount": 1
      }
    ],
    "ConnectionString": ""
  }
]

See Also

SQL Server Resource Provider Administrator Hosting Servers Interfaces