Retrieve the Database Count on a Server (MySQL)
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/mysqlservers/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 (MySQL Object). |
Example
The following code example shows a Retrieve the Database Count on a Server request.
GET https://<ServiceMgmt>:30004/services/mysqlservers/hostingServers/<ServerId>/Metrics/DatabaseCount?startTime=2013-08-27T23:51:56.7613394Z&endTime=2013-08-28T23:51:56.7613394Z HTTP/1.1
x-ms-version: 2012-03-01
Accept: application/json
Authorization: Bearer <Token>
x-ms-client-request-id: 59098650-61da-4dc3-9472-b5eee712be0a-2013-08-28 23:51:56Z
x-ms-client-session-id: aa1ca0e4-94b9-4db6-97ab-e1ed667173d7
x-ms-principal-id: <SERVICEMGMT>%5cAdministrator
Accept-Language: es-ES
Host: <ServiceMgmt>:30004
Connection: Keep-Alive
The following code example shows a Retrieve the Database Count on a Server response.
{
"Code": null,
"Message": null,
"Data": {
"Name": "DatabaseCount",
"Dimensions": [
],
"PrimaryAggregationType": "Total",
"Unit": "Count",
"MetricAvailabilities": [
],
"EndTime": "2013-08-28T23:00:00",
"StartTime": "2013-08-27T23:00:00",
"Values": [
{
"TimeCreated": "2013-08-28T23:00:00",
"Total": 1,
"Minimum": 1,
"Maximum": 1,
"Count": 1
},
{
"TimeCreated": "2013-08-27T23:00:00",
"Total": 0,
"Minimum": 0,
"Maximum": 0,
"Count": 1
}
],
"TimeGrain": "01:00:00"
}
}