This table contains information about the requests and responses in HTTP and HTTPS sessions.
NOTE: The structure of these database tables may change in future One Identity Safeguard for Privileged Sessions (SPS) versions.
Table 21: Columns of the http_req_resp_pair table
id |
integer |
The unique ID of the entry. |
url |
text |
The URL of the HTTP request. |
channel_id |
integer |
The ID of the channel. This value is actually a reference to the id column of the channels table. |
response_code |
text |
The status code of the HTTP response. |
request_time |
integer |
Unix timestamp indicating when the request has been received. |
NOTE: The structure of these database tables may change in future One Identity Safeguard for Privileged Sessions (SPS) versions.
Table 22: Columns of the indexer_jobs table
audit_trail_id |
integer |
Identifies the audit trail using the _connection_channel_id of the channel for which the indexing job was created. |
id |
integer |
The unique ID of the entry. |
indexer_adp_version |
text |
The version number of the ADP component of the indexer service. |
indexer_cpu_time |
integer |
The duration of the indexing (CPU time), in millisecond. |
indexer_duration |
integer |
The duration of the indexing (actual time), in millisecond. |
indexer_start_time |
timestamp |
Time when the indexing started. |
indexer_version |
text |
The version number of the indexer service. |
job_id |
text |
The unique ID of the indexing job, used by components of the indexing service during indexing only. |
error_message |
text |
The error message of the indexer job. |
trail_is_archived |
boolean |
The value is true if the trail is already archived. |
NOTE: The structure of these database tables may change in future One Identity Safeguard for Privileged Sessions (SPS) versions.
Table 23: Columns of the occurrences table
end_time |
integer |
The time when the token (keyword) disappears in the audit trail. |
id |
integer |
The unique ID number of the entry. |
result_id |
integer |
An ID identifying the occurrence of the token. This value is a reference to the id column of the results table. |
screenshot |
text |
A hash of the screenshot used in the report. The actual screenshot is not stored in the database. |
start_time |
integer |
The time when the token (keyword) appears in the audit trail. |
NOTE: The structure of these database tables may change in future One Identity Safeguard for Privileged Sessions (SPS) versions.
This table contains information only about Audit Player indexers. It does not contain any information about the indexer service.
Table 24: Columns of the progresses table
audit |
text |
Audit-trail: Name and ID of the audit file storing the traffic of the channel. If the session has an audit trail, a icon is displayed. Note that a the following letters may appear on the download icon: |
ap_id |
integer |
[OBSOLETE] The ID of the Audit Player indexer service that is processing the audit trail. |
id |
integer |
The unique ID number of the entry. |