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
Important
Temporarily unavailable.
| 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
Important
Temporarily unavailable.
| 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
Important
Temporarily unavailable.
| 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 about a year ago