UiPath Insights

The UiPath Insights Guide

Insights Data Model

This page details the Jobs, Queue Item, Robot Logs , Long-running Workflows, and License data that is ingested into Insights to create its data cube.

Data

Description

Id

The row ID of the job event in the Orchestrator database.
Note: Only jobs that have reached a final status are imported.

TenantId

The ID of the Orchestrator tenant.

ProcessVersion

The version number of the process the job belongs to.

RobotName

The name of the Robot that executed the job.

RobotType

The type of robot that executed the job. The available options are:
Attended
Unattended
NonProduction
Studio / StudioX / StudioPro
Other

HostMachineName

The name of the machine where the robot executed the job.

JobId

The row ID of the job event in the Orchestrator database.

TimeStamp

The time when the final job event was logged.

JobAction

The type of job event. For Insights purposes, this value is always Status.

JobState

The status of the job. See Job States for all available states and their descriptions.

JobStateVal

The numerical representation of the JobState.

UserName

The name of the user that created the job.

CreationTime

The time when the job was created.

StartTime

The time when execution of the job began.

EndTime

The time when execution of the job finished.

JobKey

The key of the job (GUID).

JobSource

The triggering event for job execution. The available options are:
Manual
Schedule
Other

EnvName

The Environments where the job was executed.

OrgUnitCode

The numerical identifier of the Folder where the environment is located.

OrgUnitName

The name of the Folder where the environment is located.

ProcessName

The name of the process.

ProcessId

The numerical identifier of the job process, comprised of ProcessName, OrganizationUnitId.

RuntimeInSeconds

The duration, in seconds, of the job execution. Computed as the difference between StartTime and EndTime.

Folder

Folder where the job is defined.

Data

Description

AnalyticsId

The auto-incremented row ID of the queue item.

Id

The auto-incremented row ID of the queue item in the Orchestrator database.

TenantId

The ID of the Orchestrator tenant.

LastQueueItemEventId

The Id of the queue item event showing the final status (e.g. Successful, Failed, or Abandoned).

Priority

The priority of the queue item defined when setting its properties from Studio.

QueueName

The name of the queue.

ProcessingStatus

The status of the queue item. The available options are:
Successful
Failed
Abandoned

ReviewStatus

The review status of the queue item.

RobotName

The name of the robot that processed the queue item.

RobotType

The type of robot that processed the queue item. The available options are:
Attended
Unattended
NonProduction
Studio / StudioX / StudioPro
Other

SnapshotTime

The time the data was moved from Orchestrator to Insights.

CreationTime

The time the queue item was created.

StartProcessing

The time the robot began processing the queue item.

EndProcessing

The time the robot finished processing the queue item.

TransactionDurationInSeconds

The processing time, in seconds, of the queue item. Computed as the difference between StartProcessing and EndProcessing.

CreatorJobId

The Id of the job that created the transaction.

ExecutorJobId

The Id of the job that executed the transaction.

SecondsInPreviousAttempts

The time, in seconds, of all attempts to process the transaction.

AncestorId

The Id of the previous attempt to process the transaction. Only applicable to Retry transactions.

RetryNumber

The number of times the processing of the transaction has been attempted. For the first attempt, 0 is displayed.

DeferDate

The earliest date and time the queue item is available for processing. If empty, it can be processed immediately.

DueDate

The latest date and time which the queue item must be processed by. If empty, it can be processed at any time.

Progress

Custom progress information for queue items with status InProgress.

SpecificData

A collection of key value pairs containing custom data associated with the transaction. See here for details.

AnalyticsData

A collection of key value pairs containing custom data for analytics purposes associated with the transaction. See here for details.

Output

A collection of key value pairs containing custom data upon successful processing associated with the transaction. See here for details.

ProcessingExceptionType

The type of the exception thrown when processing fails. The available exception types are:
ApplicationException
BusinessException

ProcessingExeptionReason

The details of the exception thrown when processing fails.

Reference

The user-specified value for identification purposes provided when adding the queue item in Studio.

ReviewerUserName

The user name of the assigned reviewer, if any.

OrgUnitCode

The numerical identifier of the Folder where the environment is located.

OrgUnitName

The name of the Folder where the environment is located.

QueueId

The numerical identifier of the queue, comprised of QueueName, OrganizationUnitId.

Folder

Folder where the queue is defined.

Data

Description

Id

The auto-incremented row ID of the log in the Orchestrator database.

TenantId

The ID of the Orchestrator tenant.

OrganizationUnitId

The name of the Folder where the log was generated.

TimeStamp

The time the logging was executed.

JobKey

The key of the job that generated the log message.

MachineId

The Id of the machine that generated the log message.

ProcessName

The name of the process that generated the log message.

WindowsIdentity

The user under which the robot generating the log message was logged in.

RobotName

The name of the robot that generated the log message.

RawMessage

JSON output from the execution log.

TransactionId

The key of the associated queue item.

Message

The logged message.

Level

The severity level at which the message was logged. See Logging Levels for details.

Long Running Workflows

Data

Description

Id

The row ID of the job event in the Orchestrator database.
Note: Only jobs that have reached a final status are imported.

TenantId

The ID of the Orchestrator tenant.

ProcessVersion

The version number of the process the job belongs to.

RobotName

The name of the Robot that executed the job.

RobotType

The type of robot that executed the job. The available options are:
Attended
Unattended
NonProduction
Studio / StudioX / StudioPro
Other

HostMachineName

The name of the machine where the robot executed the job.

JobId

The ID of the parent job that this task was run under.

TaskStartTime

The start time of this individual task.

TaskStartTimeLocal

The start time of this individual task in the timezone defined by the Orchestrator host admin or tenant.

JobAction

The type of job event. For Insights purposes, this value is always Status.

JobState

The status of the job. See Job States for all available states and their descriptions.

JobStateVal

The numerical representation of the JobState.

UserName

The name of the user that created the job.

CreationTime

The time when the job was created.

CreationTimeLocal

The time when the job was created in the timezone defined by the Orchestrator host admin or tenant.

StartTime

The time when execution of the job began.

StartTimeLocal

The time when execution of the job began in the timezone defined by the Orchestrator host admin or tenant.

EndTime

The time when execution of the job finished.

EndTimeLocal

The time when execution of the job finished in the timezone defined by the Orchestrator host admin or tenant.

JobKey

The key of the job (GUID).

JobSource

The triggering event for job execution. The available options are:
Manual
Schedule
Other

EnvName

The Environments where the job was executed.

OrgUnitCode

The numerical identifier of the Folder where the environment is located.

OrgUnitName

The name of the Folder where the environment is located.

Folder

The fully qualified name of the Folder where the environment is located.

OrganizationUnitId

The numeric representation of the folder.

ProcessName

The name of the process.

ProcessId

The numerical identifier of the job process, comprised of ProcessName, OrganizationUnitId.

RuntimeInSeconds

The duration, in seconds, of the job execution. Computed as the difference between StartTime and EndTime.

TaskEndTime

The end time of this individual task.

TaskEndTimeLocal

The end time of this individual task in the timezone defined by the Orchestrator host admin or tenant.

ActiveRunTimeInSeconds

The amount of time in seconds that this individual task was in the 'Running' state. This is 0 if the task is not running.

Folder

Folder where the long running workflow is defined.

LicenseData

Data

Description

Day

The date at a day precision when licenses were utilized

RuntimeType

Type of a runtime (aka "license type") that was used

Used

Number of used slots of the runtime

Total

Total number of slots of the runtime available that day

LicenseDataPerMachine

Data

Description

Day

The date at a day precision when licenses were utilized

MachineKey

MachineKey that identifies a robot, service or a user (depending on a RuntimeType) that used licenses

RuntimeType

Type of a runtime (aka "license type) that was used

Used

Number of used slots of the runtime

Total

Total number of slots of the runtime available that day

Updated 2 months ago


Insights Data Model


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.