- Release Notes
- Getting Started
- About Insights
- Insights Data Model
- Installation and Upgrade
- Access and Permissions
- Interacting with Insights
- Troubleshooting
Insights Data Model
This page details the Jobs,Queues, and Robot Logs data that Insights ingests. For information around the Manual Values explores, see Templates.
The data is surfaced via Explores, which you can think of as a general entity that corresponds to the fields within it. For example, to build dashboards around Orchestrator jobs, pick the Jobs Explore. Each Explore surfaces views that contain the respective data. You can access related data from within Explores, i.e. Robot Logs are accessible from the Jobs Explore, etc.
Two terms, dimension and measure, are often used in the Insights data model tables. See their definitions below:
- Dimension
- Dimensions are the fields on a table, the attributes of your data. For example, the Country dimension indicates the country (France, Germany). You can aggregate these attributes and use measures for them. For more information on dimensions, check the official Looker documentation.
- Measure
- A measure is the calculation that is done on a dimension, on a field of table. This is a numerical attribute of your data, such as sum, average, min, or max. For more information on measure, check the official Looker documentation.
|
Dimensions |
Description |
|---|---|
|
Process Version |
The version number of the process the job belongs to. |
|
Robot Name |
The name of the Robot that executed the job. |
|
Robot Type |
The type of robot that executed the job. The available options are:
|
|
Host Machine Name |
The name of the machine where the robot executed the job. |
|
Job Id |
The row ID of the job event in the Orchestrator database |
|
Job State |
The status of the job. See Job States for all available states and their descriptions. Insights only ingests terminal states (i.e. successful, stopped, and faulted) |
|
User Name |
The name of the Orchestrator user that ran the job. |
|
User Type |
The type of user type that executed the job. The available options are:
|
|
Creation Time |
The time when the job was created. |
|
Start Time |
The time when execution of the job began. |
|
End Time |
The time when execution of the job finished. |
|
Job Source |
The triggering event for job execution. The available options are:
|
|
Environment Name |
The Environments where the job was executed. |
|
Process Name |
The name of the process. |
|
Process Display Name |
The display name of the process as entered in Orchestrator. |
|
Job Duration in Seconds |
The duration, in seconds, of the job execution.
Computed as the difference between
StartTime and
EndTime.
|
|
Folder |
Folder where the job is defined. |
|
Measures |
Description |
|---|---|
|
Faulted Jobs |
The number of jobs with the
Faulted
status.
|
|
Faulted Rate |
The % of jobs with the
Faulted
status compared to the total number of jobs.
|
|
Processes Ran |
The number of processes that have reached a final
status of
Successful, Faulted, or
Stopped.
|
|
Success Rate |
The % of jobs with the
Successful
status compared to the total number of jobs.
|
|
Successful Jobs |
The number of jobs with the
Successful status.
|
|
Time in Pending in Seconds |
The amount of time all jobs spent in the
Pending status, meaning how long it took from
the moment the job was queued until it actually ran on the
robot.
|
|
Total Run Time in Seconds |
The total processing time of all jobs in seconds. |
|
Dimensions |
Description |
|---|---|
|
Priority |
The priority of the queue item defined when setting its properties from Studio. |
|
Queue Item Id |
The auto-incremented row ID of the queue item in the Orchestrator database. |
|
Queue Name |
The name of the queue. |
|
Processing Status |
The status of the queue item. The available options are:
|
|
Review Status |
The review status of the queue item. |
|
Robot Name |
The name of the robot that processed the queue item. |
|
Robot Type |
The type of robot that executed the job. The available options are:
|
|
Creation Date |
The time the queue item was created. |
|
Start Processing Date |
The time the robot began processing the queue item. |
|
End Processing Date |
The time the robot finished processing the queue item. |
|
Transaction Duration in Seconds |
The processing time, in seconds, of the queue item.
Computed as the difference between
Start Processing
Date and End Processing Date.
|
|
Seconds In Previous Attempts |
The time, in seconds, of all attempts to process the transaction. |
|
Retry Number |
The number of times the processing of the transaction
has been attempted. For the first attempt,
0 is
displayed.
|
|
Defer Date |
The earliest date and time the queue item is available for processing. If empty, it can be processed immediately. |
|
Due Date |
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. |
|
Specific Data |
A collection of key value pairs containing custom data associated with the transaction. See here for details. |
|
Analytics Data |
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. |
|
Processing Exception Type |
The type of the exception thrown when processing fails. The available exception types are:
|
|
Processing Exeption Reason |
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. |
|
Reviewer User Name |
The user name of the assigned reviewer, if any. |
|
Queue Id |
The numerical identifier of the queue, comprised of
QueueName, OrganizationUnitId.
|
|
Folder |
Folder where the queue is defined. |
|
Measures |
Description |
|---|---|
|
Avg Queue Wait Time in Seconds |
How long it takes, on average, between when all queue items were created and when a robot started processing them. |
|
First Pass Yield % Per Queue |
The percentage of time that the queue item was successful on its first try at processing (retry number =0). |
|
Queue Count |
The number of queues with data processed on this tenant. |
|
Queue Item Count |
The number of queue items processed on this tenant. |
|
Data |
Description |
|---|---|
|
Id |
The auto-incremented row ID of the log in the Orchestrator database. |
|
Timestamp Date |
The time the logging was executed. |
|
Machine Id |
The
Id of the machine that generated
the log message.
|
|
Machine Name |
The Machine Name. |
|
Process Name |
The name of the process that generated the log message. |
|
Process Version |
The version number of the process the job belongs to. |
|
Windows Identity |
The user under which the robot generating the log message was logged in. |
|
Robot Name |
The name of the robot that generated the log message. |
|
Raw Message |
JSON output from the execution
log.
Note: There is a known issue related to Raw
Message in the 2021.10 release. Please contact support to
enable this field for ingestion.
|
|
Transaction Id |
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. |
|
Log Type |
Generated according to the process designed by the user in Studio, when using the Log Message activity or the Write Line activity. These logs have a value of
User.
|
|
Queue Name |
The name of the queue. |
|
File Name |
The name of the file that created the automation. |
