Detailed Session Statistics
3 min
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