Jump to

• Request
• Response

Get database SQL summary information for an application server ID

get

/serviceapi/apm.dataserver/api/v1/appservers/{appserverId}/databaseSqls

Retrieve database SQL summary information for an application server ID. For more information see @XSERVER_DATABASE.

Request

Supported Media Types

• application/json

Path Parameters

• appserverId: string
  ID of application server (see Get application servers and their JVM metrics or similar). For more information see Object ID Parameters.

Query Parameters

• isDatabaseOverview: string
  Is this in context to database overview (true or false)

  Default Value: false
• limit(optional): integer(int32)
  Maximum number of elements in the result set, useful for paging [default = all, max = 1000]. For more information see Paging.
• offset(optional): integer(int32)
  Offset into result set at which to start returning data, useful for paging [default = 0].
• orderBy(optional): string
  Comma-separated list of one or more attributes by which the result set is ordered [default = null]. For more information see Sorting. Use attribute or attribute:asc or attribute:desc. Valid attributes can be found by using Get resource metadata with metadataType = OrderBy and metadataQuery resource = /requests
• q(optional): string
  Query clause of one or more predicates to restrict the result set to those objects satisfying the clause [default = null]. For more information see Filtering. Use query like predicates, such as attribute<=value< code>. Multiple predicates should be parenthesized and joined by AND or OR. Valid attributes can be found by using Get resource metadata with metadataType = Filter and metadataQuery resource = /requests
• since: string
  Retrieve results from start of time period, format yyyy-MM-dd'T'HH:mm:ss.SSS'Z' (e.g. 2015-11-23T22:11:05.000Z). For more information see Since and Until Time Range.
• until: string
  Retrieve results until end of time period, format yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

Back to Top

Response

Supported Media Types

• application/json

200 Response

Completed successfully, result may be null. See Status Codes for information about other possible HTTP response status codes.

Body ()

Root Schema : DatabaseSqlSummary

Type: object

Database SQL summary for an App Server (DatabaseSqlSummary)

Show Source

• averageResponseTime(optional): number
• dbConnInfoId(optional): string
• errorCount(optional): integer(int64)
• linkCollection(optional): array linkCollection
  See Links to Related Resources for more information
• maxResponseTime(optional): number
• minResponseTime(optional): number
• percImpactOnReq(optional): number
• queryTimeRange(optional): object TimeRange
• sqlConnectionInfo(optional): string
• sqlCount(optional): integer(int64)
• sqlId(optional): string
• sqlText(optional): string
• sqlTimeRangeEnd(optional): integer(int64)
• sqlTimeRangeStart(optional): integer(int64)
• warnings(optional): array warnings
  Informational or Error messages

{
    "type":"object",
    "properties":{
        "sqlId":{
            "type":"string"
        },
        "sqlText":{
            "type":"string"
        },
        "minResponseTime":{
            "type":"number"
        },
        "maxResponseTime":{
            "type":"number"
        },
        "sqlCount":{
            "type":"integer",
            "format":"int64"
        },
        "errorCount":{
            "type":"integer",
            "format":"int64"
        },
        "sqlConnectionInfo":{
            "type":"string"
        },
        "sqlTimeRangeStart":{
            "type":"integer",
            "format":"int64"
        },
        "sqlTimeRangeEnd":{
            "type":"integer",
            "format":"int64"
        },
        "dbConnInfoId":{
            "type":"string"
        },
        "percImpactOnReq":{
            "type":"number"
        },
        "averageResponseTime":{
            "type":"number"
        },
        "linkCollection":{
            "type":"array",
            "description":"See <a href='RD_Links_Resources.html'>Links to Related Resources</a> for more information",
            "items":{
                "$ref":"#/definitions/Link"
            }
        },
        "queryTimeRange":{
            "description":"Integer query time range used by server to run user query; see <a href='QP_Since_and_Until_Time_Range.html'>Since and Until Time Range</a> for more information",
            "$ref":"#/definitions/TimeRange"
        },
        "warnings":{
            "type":"array",
            "description":"Informational or Error messages",
            "items":{
                "$ref":"#/definitions/ErrorMessage"
            }
        }
    },
    "description":"Database SQL summary for an App Server (DatabaseSqlSummary)"
}

Nested Schema : linkCollection

Type: array

See Links to Related Resources for more information

Show Source

• Array of: object Link
  Information about a Link to a resource

{
    "type":"array",
    "description":"See <a href='RD_Links_Resources.html'>Links to Related Resources</a> for more information",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : TimeRange

Type: object

Show Source

• sinceTime(optional): integer(int64)
  Results are returned *since* this timestamp
• timeInMinutes(optional): integer(int64)
• untilTime(optional): integer(int64)
  Results are returned *until* this timestamp

{
    "type":"object",
    "properties":{
        "timeInMinutes":{
            "type":"integer",
            "format":"int64"
        },
        "sinceTime":{
            "type":"integer",
            "format":"int64",
            "description":"Results are returned *since* this timestamp"
        },
        "untilTime":{
            "type":"integer",
            "format":"int64",
            "description":"Results are returned *until* this timestamp"
        }
    }
}

Nested Schema : warnings

Type: array

Informational or Error messages

Show Source

• Array of: object ErrorMessage
  An error message

{
    "type":"array",
    "description":"Informational or Error messages",
    "items":{
        "$ref":"#/definitions/ErrorMessage"
    }
}

Nested Schema : Link

Type: object

Information about a Link to a resource

Show Source

• baseUrl(optional): string
  The base URL for the link
• href: string
  The href portion of the link
• post(optional): string
  The post data of the link
• rel: string
  The relationship name of the link

{
    "type":"object",
    "required":[
        "href",
        "rel"
    ],
    "properties":{
        "rel":{
            "type":"string",
            "description":"The relationship name of the link"
        },
        "href":{
            "type":"string",
            "description":"The href portion of the link"
        },
        "baseUrl":{
            "type":"string",
            "description":"The base URL for the link"
        },
        "post":{
            "type":"string",
            "description":"The post data of the link"
        }
    },
    "description":"Information about a Link to a resource"
}

Nested Schema : ErrorMessage

Type: object

An error message

Show Source

• detail: string
  A detailed description of the error
• errorType(optional): string
  Allowed Values: [ "INFO", "WARNING", "VALIDATION", "ERROR" ]

  The error type
• message: string
  The error message

{
    "type":"object",
    "required":[
        "detail",
        "message"
    ],
    "properties":{
        "errorType":{
            "type":"string",
            "description":"The error type",
            "enum":[
                "INFO",
                "WARNING",
                "VALIDATION",
                "ERROR"
            ]
        },
        "message":{
            "type":"string",
            "description":"The error message"
        },
        "detail":{
            "type":"string",
            "description":"A detailed description of the error"
        }
    },
    "description":"An error message"
}

Back to Top