LogoLogo
HomeContact UsRegister for a live demo!Get a Quote
  • Thinfinity Remote Desktop 5
  • About This Document
  • Introduction
  • What's new in 5.0
  • Architecture
  • Security
  • Upgrade from 4.0
  • Getting Started Section
    • Getting Started
    • Installing Thinfinity® Remote Desktop
    • Using Thinfinity® Remote Desktop for the First Time
      • Verifying the Communication Settings
      • Connecting to a desktop
    • Customizing Thinfinity® Remote Desktop
      • Setting the Access Security Level
        • Access Profiles
          • RDP Profiles
            • Creating an RDP Profile
            • Editing an RDP Profile
            • Disabling an RDP Profile
            • Removing an RDP Profile
            • The "[+]" Profile
          • Weblink Profiles
            • Creating a Weblink Profile
            • Editing a Weblink Profile
            • Disabling a Weblink Profile
            • Removing a Weblink Profile
          • RD Web Access Profiles
            • Creating a RD Web Access Profile
            • Editing a RD Web Access Profile
            • Disabling a RD Web Access Profile
            • Removing a RD Web Access Profile
          • VNC / RFB Profile
            • Creating a VNC Profile
            • Editing a VNC Profile
            • Disabling a VNC Profile
            • Removing a VNC Profile
          • Telnet/SSH profile
            • Creating a Telnet Profile
            • Editing a Telnet Profile
            • Disabling a Telnet Profile
            • Removing a Telnet Profile
      • Testing Internal Access
      • Configuring Internet Access
      • Enabling Remote Sound
      • Mapping Remote Drives
        • Intermediate Disks
        • Shared Folders
    • After Customization
      • Connecting to a Desktop
      • Connecting to an Application
      • Performing a File Transfer
        • Navigating
        • File Options
        • Remote Folder Area Options
        • Downloading and Uploading files
    • Supported RDP Shortcut Keys
  • Advanced Settings Section
    • Advanced Settings
    • Thinfinity® Remote Desktop Manager
      • General
      • Broker
      • Authentication
        • OAuth/2
          • Methods
          • Settings
          • Mappings
          • Configure OAuth with Okta
          • Configure OAuth with Auth0
        • RADIUS
          • Settings
          • Mappings for SSO
        • TOTP (Time-based One-time Password)
          • TOTP Settings
      • Access Profiles
        • RDP Profile Editor
          • General
            • Setting up a Hyper-V Profile
            • Setting up an RDS Collection Profile
          • Display
          • Resources
          • Program
          • Experience
          • Advanced
          • Printer
          • Permissions
          • Restrictions
          • Access Hours
          • Authentication methods
        • Web Link Profile Editor
          • Web Link
          • Permissions
        • RD Web Access Editor
          • General
          • Permissions
        • VNC / RFB Profile Editor
          • Display
          • Permissions
          • Restrictions
          • Access Hours
          • Authentication methods
        • Telnet / SSH Profile Editor
          • Display
          • SSL
          • SSH
          • Options
          • Permissions
          • Authentication methods
          • Access Hours
          • Restrictions
      • Folders
      • Permissions
      • External DLL Authentication Method Settings
      • Duo Authentication Method Settings
        • How to configure DUO
      • SAML Authentication Method Settings
        • Configure SAML with Okta
        • Configure SAML with Centrify
  • Gateway Manager
    • Managing the SSL Certificate
      • The Default Embedded Certificate
      • A Self-Signed Certificate
      • A CA Certificate
  • License Manager
    • License Activation
    • Proxy Activation
    • Get a new Trial Serial Number
    • Activate a Serial Number Online
    • Activate a Serial Number Offline
    • Registering Your License With The License Server Manager
  • Custom Settings
    • Extend the Remote Desktop’s Toolbar
  • Customizing the Toolbar
    • Using customsettings.js
    • Using the 'connect' Method
  • Remote FX
  • Save Session
    • Record a Session
    • Play Recorded Sessions
  • Multi-touch Redirection
  • Enhanced Browser and DPI Support
    • Model Inheritance
    • Property Reference
    • The Calculation Process
    • Examples
  • Silent Install Options
  • Credentials Management
    • User-based Access Profiles
    • Credentials Management
  • Customize Translation
  • Mobile Devices Section
    • Mobile Devices
    • Getting into Thinfinity® Remote Desktop
    • Mouse Control
    • Keyboards and Toolbars
    • Gestures
    • Disconnecting from Thinfinity® Remote Desktop
    • iPad Application
      • Configuration
      • Side Bar
  • Scaling and Load Balancing Section
    • Scaling & Load Balancing
    • Scaling and Load Balancing Configurations
    • Installing Components
    • Configuring a Load Balancing Scenario
    • How to configure your license
  • Integrating Thinfinity® Remote Desktop Section
    • Integrating Thinfinity® Remote Desktop
    • SDK
      • Deploying
      • Using the SDK
      • SDK Login
      • Connect method
        • Placement
        • Destination and Authentication
        • Settings
          • kbdLayout Values
        • Features
        • Events
        • Toolbar Customization
      • Browser Resizing
      • Keystroke Methods
      • SSL Certificate
      • Demo
    • External Authentication
      • Apikey
    • Single Sign On
      • Facebook OAuth Authentication Example
      • Google OAuth/2
        • Google Client ID for Web Applications
      • RADIUS
    • Customizing the Web Interface
      • Changing the Logo
      • Customizing the Web Files
      • Files Location
    • Web Services API
      • Architecture
      • Installing the Web Service
      • Setting up the Communication Settings
      • Profiles Web Service
        • Methods
        • Types
          • The WS Profile type
        • The Demo Applications
      • Analytics Web Service
        • Methods
        • Types
          • WSQueryInfo
          • WSQueryRange
          • WSDBLoginRecord
          • WSSessionRecord
          • WSDBConnectionRecord
          • WSDBBrowserRecord
        • The Demo Application
    • One-Time-URL
      • Configuring the Connection
      • Enabling Features
  • User guide Section
    • User Guide
    • Logging In
    • Advanced Web Features
      • Tree View
      • Listing Options
      • Search bar
    • Accessing from Mobile Devices
      • Connecting with Open Parameters
        • General
        • Display
        • Resources
        • Program
        • Experience
        • Advanced
      • Connecting with Profiles
    • Toolbar
      • Actions
      • File Transfer
      • Options
      • Disconnect
    • Features
      • File Transfer
        • Navigating
        • File Options
        • Remote Folder Area Options
        • Downloading and Uploading files
      • Remote Printer
      • Remote Sound
      • Share Session
      • Mapped Drives
      • Analytics
        • Sessions
        • Connections
        • Logins
        • Browsers
        • Filter
        • Configuring MS SQL Server
          • Analytics Tables Reference
    • Disconnecting
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. User guide Section
  2. Features
  3. Analytics
  4. Configuring MS SQL Server

Analytics Tables Reference

PreviousConfiguring MS SQL ServerNextDisconnecting

Last updated 4 years ago

Was this helpful?

Analytics tables

Note: The Analytics tables are automatically created when using the product or through the migration utility.

Main Tables

RemoteAccess Table: Registers the information relevant to the Thinfinity® Remote Desktop Server user access.

Field

Description

RemAccID

Auto increment field. Unique ID

AccessTime

The moment when the user accessed Thinfinity® Remote Desktop Server.

BrowserID

Reference to the browser the user accessed with, shown in the Browser table.

[User]

Username.

SourceIP

IP address that the user logged in from.

SuccessFul

1 = successful login, 0 = Error

Thinfinity® Remote Desktop Server session information

The Thinfinity® Remote Desktop Server session information is stored in two tables with a master/detail relationship.

Sessions Table: Each time a user access a remote server through Thinfinity® Remote Desktop Server an entry in the Sessions table is generated. This entry is updated with the disconnection date when the session ends (by closing the tab or browser).

Field

Description

SessionID

Auto increment field. Unique session ID.

BrowserID

Reference to Browsers table indicating which browser did the user start the session with.

[User]

Thinfinity® Remote Desktop Server logged in username.

ConnectedOn

Date/time of session start.

DisconnectedOn

Date/time of session end. If this field has a 'Null' value it means the session is still open.

EventLogs Table: In this table an entry is generated for each event related to the session referenced by the SessionID field.

Field

Description

EventLogID

Auto increment field. Unique ID.

SessionID

Reference to Sessions.SessionID. Shows the session the event belongs to.

ConnectionID

Always 0 for Thinfinity® Remote Desktop Server.

ActionID

Reference to Actions.ActionID. Shows the action of the event.

EventTime

Date/time of the event.

Message

Event message.

Protocol

Protocol. Such as: UDP, etc.

RemoteHost

Remote host, when available.

Auxiliary Tables

Actions: Fixed list container for actions referenced by the ActionID column in the EventLogs table.

Field

Description

ActionID

Action ID.

Description

Action description.

Browsers: Has a unique list of browsers detected by the product. Any reference in User Agent generates a new entry in the Browsers list. This table is references both by the RemoteAcess table and the Sessions table.

Field

Description

BrowserID

Auto increment field. Unique ID.

LongDesc

User Agent.

ShortDesc

Short description – CHROME, FIREFOX, etc.

Version

Not used for the moment.