This page details the Jobs, Queue Item, and Robot Logs 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 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 2 years ago