---
title: aioc.sc _sessions
slug: kronpam-how-to-guides/aiocsc-sessions
description: Learn about the connection details stored in a table, including primary key, session ID, username, IP address, session start and end times, target device username, initiating device IP address, server-launched application name, connection protocol, video 
docTags: 
createdAt: 2022-08-18T15:35:53.000Z
---

It stores the connection information of the established connection.     

| **Column**              | **Data Type**          | **Description**                                |
| ----------------------- | ---------------------- | ---------------------------------------------- |
| db\_id                  | bigint                 | Table's primary key                            |
| session\_id             | character varying(255) | Session id                                     |
| user\_name              | character varying(255) | Username of the session user                   |
| host                    | character varying(255) | IP of the connected device                     |
| host\_name              | character varying(255) | General name given to that device              |
| start\_time             | timestamp              | Time the session is established                |
| end\_time               | timestamp              | Time the session ended                         |
| global\_user\_name      | character varying(255) | Username used to connect to the target device  |
| client\_ip              | character varying(255) | IP of the device that initiated the connection |
| instance\_name          | character varying(255) | Name of the application started by the server  |
| access\_protocol        | character varying(255) | Connection type (MSSQL, ORACLE etc. )          |
| video\_availability     | character varying(255) | Downloadable video status                      |
| idle\_duration          | bigint                 | Idle time of user in the session               |
| reason\_for\_connection | character varying(255) | Reason stated when connecting                  |