Administering Reports › Reporting DB Views › Reporting DB Views

Reporting DB Views

The DB views return the following columns that you can use to generate the user-defined reports:

Process_Instances

The Process_Instances View contains the following columns:

Criticality

Displays the criticality level of a process instance.

Duration

Displays the duration of a process in seconds.

End_Time

Displays the time at which the process instance ended.

Expected_Duration

Indicates the expected duration for a process.

Valid Values: Days, Hours, and Minutes

Instance_Name

Displays the instance name of the running process instance.

Instance UUID

Defines the ID of an instance.

Manual_Cost

Displays the baseline manual cost for each hour.

Manual_Execution_Time

Displays the manual run time (in minutes).

Server_UUID

Defines the ID of the Orchestrator where the process is running.

Organization_Group

Defines an organization group name in support of multi-tenancy environments.

Organization_ID

Defines an organization id or name in support of multi-tenancy environments.

Parent_UUID

Defines the ID of the parent process. If the parent process is not triggered by another process, it returns a NULL value.

Path

Indicates the location of the process in the library.

Process_Version

Indicates the version of the process.

Duration_Status

Indicates the status of the runtime process instance for which the duration is defined.

Progress

Displays progress of a process.

Runtime_ROID

Displays the identifier of a row.

Root_UUID

Defines the ID of the root instance that is triggered independently.

Start_Time

Displays the time at which the process instance started.

State

Defines the state of the process.

System_Group_Name

Displays the name of an application or a system group.

User_Name

Displays the name of the user who started the process.

Warning_Threshold

Indicates how long before a process exceeds the expected duration to warn the user.

Valid Values: Days, Hours, and Minutes

Automation_Objects

The Automation_Objects View contains the following columns:

Path

Specifies the location of the Automation Object in the library.

Version

Specifies the version of the Automation Object.

Object_Type

Specifies the type of the Automation Object created.

Owner

Identifies the user who created the Automation Object.

Tags

Specifies the tags that are assigned to the Automation Object.

Creation_Date

Indicates the date on which the Automation Object was created.

Modification_Date

Indicates the date on which the Automation Object was last modified.

Operator_Instances

The Operator_Instances View contains the following columns:

Operator

Specifies the operator instance.

Module

Displays the module name to which operator belongs.

Start_Time

Displays the time at which the operator instance started.

Operator_Name

Displays the name of the operator.

End_Time

Displays the time at which the operator instance ended.