BroadSQL Download
On this page
Documentation / Commands / SHOW SESSIONS

SHOW SESSIONS

Core command SH SESS SHSESS

Lists the activity log files of past sessions, with their connections, to find the one to open.

Syntax

SHOW SESSIONS [<date> | <from> <to> | <ID>]

Arguments

ArgumentRequiredValuesDefault
<date>NoSessions started that day, written yyyy-mm-ddThe 50 most recent sessions
<from> <to>NoSessions started in that period, both days included
<ID>NoSessions whose Session ID starts with it, or whose Instance ID is it; one session is shown in detail

Examples

SHOW SESSIONS;
SHOW SESSIONS 2026-10-23;
SHOW SESSIONS 2026-10-01 2026-10-31;
SHOW SESSIONS 9c82f174;

Details

Lists the activity log files of past sessions, newest first, so that you can find the one to open. BroadSQL writes one activity log file per session (from a successful master password to LOGOUT or EXIT), in the activity log folder, when the activity log is on.

  • Without argument: the most recent sessions, at most 50.
  • <date>: the sessions started that day; <from> <to>: the sessions started in that period (dates as yyyy-mm-dd).
  • <ID>: the sessions whose Session ID starts with it, or whose Instance ID is it. A single session found is shown in detail, with its file.

Each row gives when the session started and ended, its Session ID, the Instance ID of the installation that wrote it, and the connections it opened with their Environment. A session without an end is still running, or BroadSQL stopped without being able to record it. Only the names of the files and their session lines are read: the files are listed, never changed.

Last modified in release development.

← All commands

Found something wrong or unclear on this page? , with the page address.