BigData Intelligence Full SQL domain

You can create full SQL entities by using only the following policy rule actions: Log Full Details, Log Full Details With Values, Log Full Details Per Session, or Log Full Details Per Session With Values.

Available to roles: all.

This domain is available in Guardium systems that have a defined datasource of type GBDI.

BigData Intelligence Full SQL Entity

Table 1. The following table describes the domain's entities and attributes.

Attribute	Description
Analyzed Client IP	Applies only to encrypted traffic; when set, client IP is set to zeros. Analyzed Client IP has a map for CEF source. If the query used for the CEF does NOT contain the Client IP but contains the analyzed client IP, the analyzed client IP is used for the source. If both included in the query, then Client IP takes precedence.
Client Host Name	Client hostname
Database Name	Database name
DB User Name	Database username
Full Sql	Full SQL statement with values.
Guardium Appliance	Hostname of the collector that reported this data.
Instance ID	Unique identifier for the Full SQL instance.
Network Protocol	Network Protocol
OS User	OS User
Records Affected	The number of records affected for each session. For reports that use this attribute, it's recommended to turn on aliases to properly display special cases such as Large Result Set or N/A.
Response Time	The response time for the request in milliseconds. When you monitor requests in network traffic, the response times accurately reflect the time that is taken to respond to the request (Guardium timestamps both the client request and the server response).
Server Host Name	Server hostname
Server IP	Server IP
Server Port	Server port
Server Type	Server type
Service Name	Service name
Session Id	The numeric key value that Guardium assigns to uniquely identify a session. It is used to search the activities generated during the session.
Source Program	Source Program
Succeeded	Indicates whether the call succeeded.
Timestamp	The time when the SQL was executed in the database server.
UTC Offset	The difference in time between Coordinated Universal Time (UTC) time and the time of the collector that reported that data.