Audit
The Audit page in the ADB Control web interface is designed to display statistics on ADB relation accesses (in clusters used for monitoring), as well as information on user authorizations and other operations in ADB Control. This page includes three tabs, each of which is described in detail below.
Relations
The Relations tab on the Audit page displays the number of user calls to relations of databases located in ADB clusters that are used for monitoring. You can view data for the current date, week, or month.
On the tab, there is a table with the following information.
| Field | Description |
|---|---|
Database |
A database name |
Schema |
A schema name |
Relation |
A relation name |
Times accessed |
A number of calls to the specified relation for the time period that is defined in the Select time period filter |
Last accessed |
A timestamp of the last access to the specified relation in the |
Above the table with a list of relations, there are filters that you can use to select specific data. Available filters are listed below:
-
Search schema… — filter by the schema name (see Schema above). You can search by the first characters entered.
-
Search relation… — filter by the relation name (see Relation above). You can search by the first characters entered.
-
Database — filter by the database name (see Database above). Select a value from the drop-down list. This list contains databases of the ADB cluster that is selected in the field located to the left of the Database field. By default all cluster databases are selected.
-
Select time period — filter by the last access time (see Last accessed above). Select one of the following values:
-
day— current day; -
week— current week; -
month— current month.
-
Operations
The Operations tab on the Audit page displays a list of operations launched by ADB Control users during the specified time period. Current day data is displayed by default.
On the tab, there is a table with the following information.
| Field | Description |
|---|---|
Object name |
An object name |
Object type |
A type of the object on which the operation has been performed. Possible values:
|
Operation type |
A type of the operation that has been applied to the Object name object. Possible values:
|
Result |
An operation result. Possible values:
|
Time |
An operation end timestamp in the |
Username |
A name of the user who performed the operation |
Host |
IP address of the host from which the operation was initiated |
Above the table with operation list, there are filters that you can use to select specific data. Available filters are listed below:
-
Search object name… — filter by the object name (see Object name above). Enter a full value.
-
Search username… — filter by the user name (see Username above). Enter a full value.
-
Search host… — filter by the host IP address (see Host above). Enter a full value.
-
Object type — filter by the object type (see Object type above). Select a value from the drop-down list.
-
Operation type — filter by the operation type (see Operation type above). Select a value from the drop-down list.
-
Operation result — filter by the operation result (see Result above). Select a value from the drop-down list.
In filters, you can also specify a time range to select operations by the end timestamp (see Time above). To do this, click the field with the start or end date of the range and select a new value from the calendar.
Authorizations
The Authorizations tab on the Audit page displays a list of ADB Control user authorizations for the selected time period. It displays both successful and failed login attempts. Additionally, you can see there failed authorizations in ADB. Current day data is displayed by default.
On the tab, there is a table with the following information.
| Field | Description |
|---|---|
Event time |
An event timestamp in the |
Username |
A user name |
Session |
A unique session identifier |
Message |
An error message. For example, the following message indicates incorrect credentials: |
Auth type |
An authorization type:
|
Type |
An event type. Possible values:
|
Result |
An event result. Possible values:
|
Host |
IP address of the host from which the event was initiated. This column becomes visible after table customization |
Session Time |
A start timestamp of the session (within which the current event took place) in the |
If necessary, you can add columns to the table. To do this, click Customize table and select column names in the section that opens. Currently you can add the Host and Session Time columns (see column descriptions above).
Above the table with authorization events, there are filters that you can use to select specific data. Default filters are listed below:
-
Search username… — filter by the user name (see Username above). Enter a full value.
-
Search session… — filter by the session identifier (see Session above). Enter a full value.
-
Result — filter by the event result (see Result above). Select a value from the drop-down list.
-
Auth type — filter by the ADB Control/ADB authorization type (see Auth type above). Select a value from the drop-down list.
-
Type — filter by the event type (see Type above). Select a value from the drop-down list.
In filters, you can also specify a time range to select events by the end timestamp (see Event time above). To do this, click the field with the start or end date of the range and select a new value from the calendar.
You can also add filters by the host IP address. To do this, click Add filters and select the Host item in the drop-down list that opens.
