$listSessions (aggregation stage)

Definition

$listSessions

Lists all sessions stored in the system.sessions collection in the config database. These sessions are visible to all members of the MongoDB deployment.

Important

When a user creates a session on a mongod or mongos instance, the record of the session initially exists only in-memory on the instance; i.e. the record is local to the instance. Periodically, the instance will sync its cached sessions to the system.sessions collection in the config database, at which time, they are visible to $listSessions and all members of the deployment. Until the session record exists in the system.sessions collection, you can only list the session via the $listLocalSessions operation.

To run $listSessions, it must be the first stage in the pipeline.

The stage has the following syntax:

{ $listSessions: <document> }

The $listSessions stage takes a document with one of the following contents:

Field	Description
{ }	If running with access control, returns all sessions for the current authenticated user. If running without access control, returns all sessions.
{ users: [ { user: <user>, db: <db> }, ... ] }	Returns all sessions for the specified users. If running with access control, the authenticated user must have privileges with listSessions action on the cluster to list sessions for other users.
{ allUsers: true }	Returns all sessions for all users. If running with access control, the authenticated user must have privileges with listSessions action on the cluster.

Restrictions

$listSessions is not allowed in transactions.

Examples

use config
db.system.sessions.aggregate( [  { $listSessions: { allUsers: true } } ] )

use config
db.system.sessions.aggregate( [ { $listSessions: { users: [ {user: "myAppReader", db: "test" } ] } } ] )

use config
db.system.sessions.aggregate( [ { $listSessions: { } } ] )

const db = client.db("config");
const collection = db.collection("system.sessions");
const pipeline = [{ $listSessions: { allUsers: true } }];
const cursor = collection.aggregate(pipeline);
return cursor;

const db = client.db("config");
const collection = db.collection("system.sessions");
const pipeline = [
  { 
    $listSessions: { 
      users: [{ user: "myAppReader", db: "test"}] 
    } 
  }
];
const cursor = collection.aggregate(pipeline);
return cursor;

const db = client.db("config");
const collection = db.collection("system.sessions");
const pipeline = [{ $listSessions: {} }];
const cursor = collection.aggregate(pipeline);
return cursor;

Output

$listSessions returns a cursor with one document per session. Each document has the following prototype:

{
   _id: {
      id: <UUID>,
      uid: <BinData>
   },
   lastUse: <date>
}