---
title: Detailed Session Statistics
slug: kronpam-how-to-guides-180/detailed-session-statistics
description: Learn how to filter data and analyze important metrics related to Single Connect with this informative document. Get valuable insights from charts showcasing blocked commands, active sessions by user, average session duration by user, and session statisti
docTags: 
createdAt: 2022-08-18T16:43:19.000Z
---

# Filter

Data can be filtered by:

- Date
- Policy Query Type
- Device 
- User
- Access Protocol

# Charts

- **of Blocked Commands:** \{\*}Shows which commands are blocked by Kron PAM. The following two tables are used.

| **Sc\_userlog**  | Logs and Session\_id are kept in this table                                                                                       |
| ---------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| **Sc\_sessions** | Sc\_userlog held in the table session\_id with the realm discarded so that the knowledge of the person who will be reached query. |

** **

- **of Active Sessions by User: **The chart that lists the users who are logged on and not logged off. When a new session is opened, a session with **end\_time ***null *is added to the **sc\_sessions **table. In this chart, **end\_time **pulls all the sessions that are null, meaning the connection is not closed yet.


- **Average Session Duration By User: **Chart that shows how long an average user is active in all sessions. When the user opens the session, a new session is added to the **sc\_sessions** table as in the previous chart. When the session is first opened, **start\_time** is the moment it starts and **end\_time***** ***indicates the closing time of the session. This chart calculates** (end \_time - start\_time)*** *to average the session duration.


- **Session Statistics by System Name: **Chart showing how long the sessions established to the devices remain open per device. While the previous chart is the average active time of the users, this chart shows the average active time regardless of the user on the connected device.End\_time -start\_time is similar to the previous chart. However, instead of a user-based average, a device-based (by grouping host\_name) average is used.

**System Name:** Device name
**# of Sessions: **Number of sessions opened to the device
**AVG (duration): **Average session duration