---
title: Session Logs
slug: kronpam-reference-guide-3-9-0/session-logs
docTags:
createdAt: 2025-07-16T09:57:47.836Z
---
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.** |
| **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. |
| **Show Statement** | Option for viewing all SQL queries run during that session in a time-ordered list, including command type, exact query text, and other metadata. |
