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