**Please note this idea was migrated to the Product Feedback Forum from older submission areas**
Sisense doesn’t have an API to get data from the Sessions Table. This data is available in the UI on...
Simple nodejs code:
const uri = `mongodb://sisense-mongodb-headless:27017`;
const client = new MongoClient(uri);
try {
const db = client.db("prismWebDB");
const collection = db.collection("socket-sessions");
const sessions = (await collection.find(
{"registrationDetails.headers.authentication.isAuthenticated": true},
{_id: 0, "registrationDetails.details": 1}
).toArray()).map(s => s.registrationDetails.details);
logger.debug("Session data (mongodb): " + JSON.stringify(sessions));
return sessions;
} catch(e) {
logger.error("Reading sessions failure", e);
} finally {
await client.close();
}