Get Hosting Server Metrics Database Count

Article
08/24/2015

Applies To: Windows Azure Pack

Retrieves the database count metric from a hosting server during the specified duration.

Request

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

Method	Request URI	HTTP version
GET	https://<ServiceMgmt>:30004/services/sqlservers/hostingServers/<ServerId>/Metrics/DatabaseCount	HTTP/1.1

URI Parameters

The following table describes the URI parameters.

URI Parameter	Description
startTime	The time in UTC format, to start collecting the metric.
endTime	The time in UTC format, to stop collecting the metric.

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
ResourceMetricResponse	The retrieved metric. For more information, see ResourceMetricResponse (Object).

Example

The following code example shows a Get Server Metrics Database Count request.

GET https://<ServiceMgmt>:30004/services/sqlservers/hostingServers/<ServerId>/Metrics/DatabaseCount?startTime=2013-08-26T00:43:10.2670496Z&endTime=2013-08-27T00:43:10.2670496Z HTTP/1.1
x-ms-version: 2012-03-01
Accept: application/json
Authorization: Bearer <Token>
x-ms-client-request-id: a3bd8fe0-2113-48f9-a49a-23236269fedd-2013-08-27 00:43:10Z
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 Get Server Metrics Database Count response.

{
  "Code": null,
  "Message": null,
  "Data": {
    "Name": "DatabaseCount",
    "Dimensions": [

    ],
    "PrimaryAggregationType": "Total",
    "Unit": "Count",
    "MetricAvailabilities": [

    ],
    "StartTime": "9999-12-31T23:59:59.9999999",
    "Values": [

    ],
    "TimeGrain": "01:00:00"
  }
}

Share via