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:
Data is only stored for 180 days.
TELEMETRY is automatically regenerated daily, and all past data is fully reloaded.
It is not possible to manually reload TELEMETRY with an external dataset.
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 | |
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.
|
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 |