Show Audits
Summary
The SHOW AUDITS command returns a result set listing a log of calls to REST endpoints submitted against a customer’s Connect environment. The result set shows which Connect user made a REST call, request and response bodies, and HTTP status codes. Xactly’s ODBC driver uses Connect’s REST API. Therefore, commands invoked via ODBC are captured in the audits result set.
Syntax
show audits; |
Parameters
None.
Details
The following table lists the columns of the audit log result set.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| id | string | Unique identifier for each audit row |
| session_id | string | The session id used to make the HTTP request |
| user_name | string | The Connect user who made the HTTP request |
| resource | string | The Connect REST resource that was called |
| action | string | HTTP method used |
| message | string | Reserved for future use |
| request_body | string | JSON request body submitted. xSQL and xCL commands issued via ODBC are captured within the JSON response object where resource = ‘
/connect/v1/xdbc/prepared’. |
| response_body | string | JSON response sent from Connect server. Not all requests provide response bodies. |
| response_status | integer | Connect server’s HTTP response code for the request |
| created_by | string | The Connect user associated with logged command |
| created_instant | instant | The UTC instant when the row was inserted into the audit log |
Examples
show audits;
select user_name, resource, action, request_body, response_status, created_instant
from (show audits)
where request_body like ‘%create table%’;
Related Commands
SHOW USERS