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.

Jobs

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 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 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: 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.

Queues Items

Queue Items

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.

Robot Logs

Robot Logs

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 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: 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