# Sessions: Inspectlet Inspectlet Sessions ## Documentation Session recordings of the selected websites, one row per recorded visit. - Catalog: `Inspectlet` - Schema: `Inspectlet` - Primary Keys: `sid` - Label: Inspectlet Sessions The data in this table is partitioned per value of the `` column. This is a read-only table. The Inspectlet API may not support changing the data or the Invantive UniversalSQL driver for Inspectlet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Inspectlet API. ## Table Columns The columns of the table `Sessions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `browser` | `varchar2` | | ☐ | The visitor's browser's major family name. | | `country` | `varchar2` | | ☐ | The visitor's country, as its full English name rather than as an ISO code. | | `date_end_session_utc` | `datetime` | | ☑ | The session's last recorded activity (UTC). | | `date_start_session_utc` | `datetime` | | ☑ | The session's start time (UTC), to fractions of a second. | | `device_type` | `varchar2` | | ☐ | The type of device used during this visit (desktop/phone). | | `display_name` | `varchar2` | | ☐ | The visitor's display name, as sent in when identifying the visitor from client-side JavaScript. | | `exit_page` | `varchar2` | | ☐ | The URL of the last page in the session. | | `ip` | `varchar2` | | ☐ | The visitor's IP address. | | `landing_page` | `varchar2` | | ☐ | The URL of the first page in the session. | | `mltimebucket` | `varchar2` | | ☐ | Reported by Inspectlet without a documented meaning, and carried through as text. | | `new_visitor` | `char` | | ☐ | Whether this is the first session from this visitor on this website. | | `num_pages` | `int32` | | ☑ | The total number of pages in this session. | | `page_height` | `int32` | | ☐ | The browser page height. | | `page_width` | `int32` | | ☐ | The browser page width. | | `referrer_source` | `varchar2` | | ☐ | The referring traffic source of this session, as free text. | | `session_duration` | `int64` | | ☑ | The total session duration in seconds. | | `sessionlink` | `varchar2` | | ☐ | A guest-accessible, sharable URL to watch this session recording. | | `sid` | `int64` | | ☑ | The session ID. | | `starred` | `char` | | ☐ | Whether this session recording is starred. | | `uid` | `varchar2` | | ☑ | The identifier Inspectlet uses for the visitor, reported as text. | | `useragent` | `varchar2` | | ☐ | The visitor's browser's complete user agent string. | | `wid` | `int64` | | ☑ | The website ID. |