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