One Identity Safeguard for Privileged Sessions 6.0.1

This table contains information about the files transferred the connections.

NOTE:

The structure of these database tables may change in future One Identity Safeguard for Privileged Sessions (SPS) versions.

Table 23: Columns of the file_xfer table
Column	Type	Description
channel_id	integer	This value is a reference to the ID of the channels table where the file transfer occurred.
details	text	The detailed description of the file transfer. The exact contents of this field depend on the protocol used for the file transfer.
event	text	The type of the file operation that occurred, for example, Create file.
filename	text	The name of the file affected by the file operation.
path	text	SCP path: Name and path of the file copied via SCP. Available only for SCP sessions (Session exec SCP SSH channels) if the Log file transfers to database option is enabled in the Channel Policy of the connection.
id	integer	The unique ID of the entry
start_time	integer	Start time: Date when the channel was started.

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 24: Columns of the http_req_resp_pair table
Column	Type	Description
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 25: Columns of the indexer_jobs table
Column	Type	Description
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 26: Columns of the occurrences table
Column	Type	Description
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.

One Identity Safeguard for Privileged Sessions 6.0.1 - Administration Guide