You can call this operation to query audit logs of an ApsaraDB for Redis instance.

For more information about how to perform the corresponding operation in the console, see Query audit logs of an instance.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String No DescribeAuditRecords

The operation that you want to perform. Set the value to DescribeAuditRecords.
InstanceId String Yes r-bp1xxxxxxxxxxxxx

The ID of the instance for which you want to query audit logs.
StartTime String Yes 2019-03-24T12:10:00Z

The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format.

EndTime String Yes 2019-03-25T12:10:00Z

The end of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The end time must be later than the start time.

HostAddress String No 127.0.0.1

The IP address of the client. By default, the system queries audit logs of all IP addresses.

NodeId String No r-bp1xxxxxxxxxxxxx-db-0

The ID of the child node in the cluster.
AccountName String No demo

The name of the account. By default, the system queries audit logs of all accounts.
DatabaseName String No demo

The name of the database.
QueryKeywords String No maxclients

The keyword based on which audit logs are queried. You can specify a command as a keyword. By default, the system queries audit logs of all commands that have been run.

Note You can specify only one keyword at a time.
PageSize Integer No 30

The number of entries to return on each page.
PageNumber Integer No 1

The number of the page to return.
RegionId String No cn-hangzhou

The ID of the region.

Response parameters

Parameter Type Example Description
RequestId String 9F5EB478-824E-4AC4-8D2B-58F31A028E7B

The ID of the request.
PageNumber Integer 1

The page number of the returned page.
PageSize Integer 30

The number of entries returned per page.
TotalRecordCount Integer 22222

The total number of entries returned.
InstanceName String r-bp1xxxxxxxxxxxxx

The names of the instance.
StartTime String 2019-03-24T12:10:00Z

The beginning of the time range when audit logs are queried.
EndTime String 2019-03-25T12:10:00Z

The end of the time range when audit logs are queried.
Items Array

The collection of audit logs returned.
HostAddress String 127.0.0.1

The IP address of the client.
DatabaseName String demo

The name of the database.
IPAddress String xxx.xxx.xxx.100

The IP address.
SQLText String CONFIG GET maxmemory

The command that was run.
SQLType String non_read_write

The type of the command that was run.
TotalExecutionTimes String 0

The amount of time that it took to run the command.
ExecuteTime String 2019-03-25T03:22:08Z

The time when the command was run.
AccountName String demo

The name of the account.

Examples

Sample requests

https://r-kvstore.aliyuncs.com/
?Action=DescribeAuditRecords
&InstanceId=r-bp1xxxxxxxxxxxxx
&StartTime=2018-12-04T12:10:00Z
&EndTime=2018-12-30T12:10:00Z
&<Common request parameters>

Sample success responses

XML format 

<DescribeAuditRecordsResponse>
      <Items>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:08Z</ExecuteTime>
                  <SQLText>CONFIG GET band-width</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:08Z</ExecuteTime>
                  <SQLText>CONFIG GET maxmemory</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:08Z</ExecuteTime>
                  <SQLText>CONFIG GET maxclients</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:08Z</ExecuteTime>
                  <SQLText>CONFIG GET qps</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:03Z</ExecuteTime>
                  <SQLText>CONFIG GET qps</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:03Z</ExecuteTime>
                  <SQLText>CONFIG GET maxclients</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
            <SQL>
                  <TotalExecutionTimes>0</TotalExecutionTimes>
                  <DatabaseName>0</DatabaseName>
                  <HostAddress>127.0.0.1</HostAddress>
                  <ExecuteTime>2019-03-25T03:22:03Z</ExecuteTime>
                  <SQLText>CONFIG GET maxmemory</SQLText>
                  <AccountName>0</AccountName>
                  <SQLType>non_read_write</SQLType>
            </SQL>
      </Items>
      <TotalRecordCount>36559</TotalRecordCount>
      <PageNumber>1</PageNumber>
      <PageSize>30</PageSize>
      <RequestId>9F5EB478-824E-4AC4-8D2B-58F31A028E7B</RequestId>
      <EndTime>2019-03-25T12:10:00Z</EndTime>
      <StartTime>2019-03-24T12:10:00Z</StartTime>
      <InstanceName>r-bp1xxxxxxxxxxxxx</InstanceName>
</DescribeAuditRecordsResponse>

JSON format 

{
    "Items": {
        "SQL": [
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:08Z",
                "SQLText": "CONFIG GET band-width",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:08Z",
                "SQLText": "CONFIG GET maxmemory",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:08Z",
                "SQLText": "CONFIG GET maxclients",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:08Z",
                "SQLText": "CONFIG GET qps",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:03Z",
                "SQLText": "CONFIG GET qps",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:03Z",
                "SQLText": "CONFIG GET maxclients",
                "AccountName": "0",
                "SQLType": "non_read_write"
            },
            {
                "TotalExecutionTimes": "0",
                "DatabaseName": "0",
                "HostAddress": "127.0.0.1",
                "ExecuteTime": "2019-03-25T03:22:03Z",
                "SQLText": "CONFIG GET maxmemory",
                "AccountName": "0",
                "SQLType": "non_read_write"
            }
        ]
    },
    "TotalRecordCount": 36559,
    "PageNumber": 1,
    "PageSize": 30,
    "RequestId": "9F5EB478-824E-4AC4-8D2B-58F31A028E7B",
    "EndTime": "2019-03-25T12:10:00Z",
    "StartTime": "2019-03-24T12:10:00Z",
    "InstanceName": "r-bp1xxxxxxxxxxxxx"
}

Error codes

HttpCode Error code Error message Description
400 InvalidStartTime.Malformed The Specified parameter StartTime is not valid. The error message returned because the format of the beginning time is invalid. The time must be in GMT. Example: 2011-06-11T16:00Z.
400 InvalidEndTime.Malformed The Specified parameter EndTime is not valid. The error message returned because the format of the end time is invalid. The time must be in GMT. Example: 2011-06-11T16:00Z.

For a list of error codes, visit the API Error Center.