- Release Notes
- Getting Started
- Installation and Upgrade
- Insights in Orchestrator
- Insights Portal
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:
|
|
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 Orchestrator user that ran 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:
|
|
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:
|
|
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:
|
|
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:
|
|
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. |
|
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:
|
|
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 Orchestrator 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:
|
|
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. |
|
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 |
|
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 |
