Skip to main content
All CollectionsAdministration
Content of the TELEMETRY database
Content of the TELEMETRY database

Database with daily statistics on user activity

Updated over a week ago

TELEMETRY is an internal dynamically generated database that holds daily statistics on user activity.

Each record in the database represents aggregated daily usage KPIs and user-level metrics for each account registered on the server.

Specifics and limitations

TELEMETRY is a database in DataTile that can be shared, used for calculations, and used to build dashboards and reports. However, there are several limitations to keep in mind:

  1. Data is only stored for 180 days.

  2. TELEMETRY is automatically regenerated daily, and all past data is fully reloaded.

  3. It is not possible to manually reload TELEMETRY with an external dataset.

  4. If variable or category labels are changed, they will be reverted to their default values during the next reload job.

Note! This database aggregates content locally. It is not transferred in any form outside the server itself.

Content of the TELEMETRY database

ID

Label

Description

ACCOUNT_EMAIL

Username

Email

ACCOUNT_FIRST_NAME

First name

First name of the user

ACCOUNT_LAST_NAME

Last name

Last name of the user

ACCOUNT_STATE

Account state

State of the account. It is not related to the actual activity of the account.

  • Active: valid account

  • Blocked: account has been blocked by a Supervisor, user cannot log in to the system

  • Invited: the user has been invited but not registered or admitted to the system yet

  • Moderation: account is pending for approval by a Supervisor to access the server.

  • Deleted: account has been deleted by a Supervisor and is pending it's complete removal from the server.

DATE

Date

YEAR

Year

QUARTER

Quarter

MONTH

Month

SESSION_

DURATION

Session duration

The total duration of all user sessions during the day in minutes

SERVER_LOAD_

TIME

Server load time

The total processing time of the user's requests during the day

IO_BYTES

query IO: read kB

The total IO in Kb related to the user's activity on the server during the day

PROJECT_SIZE

Database size

The sum of sizes of all databases owned by the user

COLLABORATOR_COUNT

Collaborator count

The number of collaborators attached to all user's entities

BROWSER_NAME

Browser: name

The browser that the user uses while working with the server (e.g. Chrome, Firefox, etc.)

BROWSER_

VERSION

Browser: version

The version of the user's browser

ACCOUNT_

DOMAIN

Domain

Domain of the user's email (everything that follows @)

SESSIONS_COUNT

Sessions count

The number of user's sessions during the day

USER_ROLES

User Roles

System roles that was possessed by the user during the day

ENTITY_COUNT_

DASHBOARD

Dashboard count

Number of dashboards owned by the user

ENTITY_COUNT_

REPORT

Report count

Number of reports owned by the user

ENTITY_COUNT_

ENCODER

Text refiner project count

Number of Text Refiner entities owned by the user

ENTITY_COUNT_

DICTIONARY

Text refiner dictionary count

Number of Text Refiner Dictionaries owned by the user

ENTITY_COUNT_

DATABASE

Database count

Number of Databases owned by the user

ENTITY_COUNT_

FOLDER

Folder count

Number of Folders owned by the user

ENTITY_COUNT_

ATTACHMENT

Attachment count

Number of various attachments and files owned by the user

ENTITY_COUNT_

POINTER

Pointer count

Legacy KPI, it will be removed in the future

ENTITY_COUNT_

CHART

Chart count

Number of Chart Entities owned by the user

GROUP_NAME

Team

The team that user belongs to by the end of the day

ACTIVE_DURING_DAY

Active during a day

Whether the user interacted with the server during the day

QUERY_

EXECUTED

Query executed, times

Number of calculation requests made by the user during the day

ENTITY_COUNT_

PORTAL

Portal count

Number of Portal entities owned by the user

ENTITY_COUNT_

EXECUTION

Execution count

Number of processing jobs initiated on behalf of the user via API

ENTITY_COUNT_

TRANSFORMER

Transformer count

Number of Transformer entities owned by the user

ENTITY_COUNT_

COSTTABLE

Cost table count

Number of Cost table entities owned by the user

Did this answer your question?