Session Logs

1 min

The Session Logs tab, accessible from Database Activity Monitoring > Database Session Log > Session Logs, displays historical database sessions that were previously active. This screen provides visibility into who connected to what, when, and how long.

Fields	Description
Host	IP address of the target database device.
DB Server Name	Name or label of the connected server.
Protocol	Database protocol (e.g., Oracle, MSSQL, PostgreSQL).
DB Port	Original database port.
Proxy Port	The SQL Proxy port is set for this session.
DB User	The user credentials are used at the database level.
Global User	The Kron DAM user is associated with the session.
Client IP	IP address of the connecting client.
Client OS Host	Hostname of the client machine. This field is supported only for Oracle databases.
Session Start Time	Timestamp of when the session started.
Session End Time	Timestamp of when the session ended.
Client Device	The name or identifier of the client device used. This field is supported only for MSSQL databases when Windows Authentication is enabled.
Client Program	The application used for the connection (e.g., DBeaver, DataGrip). This field is supported for MSSQL and Oracle.
Client Domain	Domain name of the client machine. This field is supported only for the MSSQL database. It requires Windows Authentication and Azure AD integration and is available starting from version.
Client User	Username from the client machine. This field is supported for Oracle, and MSSQL where it specifically requires Windows Authentication in the case of MSSQL.
DB User ID	System-assigned ID for the database user.
Total Duration	Duration of the session.
Action	Option for viewing all SQL queries run during that session in a time-ordered list, including command type, exact query text, and other metadata.

Client OS Host

This field is supported only for Oracle databases.

Client Device

This field is supported only for MSSQL databases when Windows Authentication is enabled.