UiPath Orchestrator

The UiPath Orchestrator Guide

Insights Data Model

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

Jobs

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
  • Development
  • 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.

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
  • Development
  • 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.

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.

Updated about a month 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.