| Panel | ||||
|---|---|---|---|---|
|
...
Field Name | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
General | This section contains general information about the Report. | ||||||||
| Title (name) of the Report.
Reports visible to Me, Everyone, and any number Groups can have the same title. However, there can only be a single Report, of the same title, visible to a particular Group. For example, there can be multiple Reports titled Report #1 as long as only one is visible to Me, one is visible to Everyone, and only one Report titled Report #1 is visible to any specific Group. | ||||||||
Description |
| ||||||||
| Type of Report (see 794546364 Report Output).
| ||||||||
| Universal Controller Reportable table in the Controller database on which the Report is based. | ||||||||
| Users that will be able to view this report.
| ||||||||
List Fields and Ordering | For List reports; this section allows you to select and arrange fields for the report based on the selected Universal Controller table. | ||||||||
Field(s) | Fields in the selected Universal Controller table that you want displayed on the report. | ||||||||
| Specifications for how you want fields in the Report to be sorted (see Sorting). | ||||||||
Chart Options | For Chart reports; this section allows you design the chart for the report based on the selected Universal Controller table. | ||||||||
Chart Size | Size of the displayed report.
| ||||||||
| Field in the selected Universal Controller table by which you want to group the fields in the report. | ||||||||
Group Threshold | Maximum number of groups to display on the chart, specified by the Report Group Threshold Universal Controller system property. All groups above the threshold will be displayed in one group named Other. | ||||||||
Group Order | Sequence of the groups shown in the key below the chart graphic.
| ||||||||
Group Date/Time Format | |||||||||
Stack By | Field in the selected Universal Controller table by which you want to sort records within each Group. | ||||||||
Sum Field | Sum of the integers in the field in the selected Universal Controller table by which you want to group the fields in the report. | ||||||||
Bar Thickness | Thickness of the bars on the chart. | ||||||||
| Show Average | Indication of whether or not to display the average line on the bar chart. | ||||||||
| Average Color | If Show Average is checked; Hexadecimal color of the average line. If an average color is not specified, the color is determined by the Report Average Color Universal Controller system property. | ||||||||
| Show Threshold | Indication of whether or not to display the threshold line on the bar chart. | ||||||||
| Threshold Color | If Show Threshold is checked; Hexadecimal color of the threshold line. If a threshold color is not specified, the color is determined by the Report Threshold Color Universal Controller system property. | ||||||||
| Threshold Value | If Show Threshold is checked; Integer value for the threshold line. | ||||||||
| Threshold Label | If Show Threshold is checked; Label for the threshold line. If a threshold label is not specified, the label will be Threshold. | ||||||||
| This section allows you to override the values of Universal Controller System Properties for scheduled reports. | ||||||||
PDF Orientation | If 794546364 Type is List; Orientation of the scheduled report PDF.
| ||||||||
PDF Size | If 794546364 Type is List; Size of the scheduled report PDF.
| ||||||||
Image Width | If 794546364 Type is Bar Chart/Horizontal, Bar Chart/Vertical, Pie Chart; Width (in pixels) of the scheduled chart report (overrides Scheduled Report Image Width system property). | ||||||||
Image Height | If 794546364 Type is Bar Chart/Horizontal, Bar Chart/Vertical, Pie Chart; Height (in pixels) of the scheduled chart report (overrides Scheduled Report Image Height system property). | ||||||||
Filter | This section allows you filter entries displayed in the Report (see Filters).
| ||||||||
Metadata | This section contains Metadata information about this record. | ||||||||
UUID | Universally Unique Identifier of this record. | ||||||||
Updated By | Name of the user that last updated this record. | ||||||||
Updated | Date and time that this record was last updated. | ||||||||
Created By | Name of the user that created this record. | ||||||||
Created | Date and time that this record was created. | ||||||||
Buttons | This section identifies the buttons displayed above and below the Report Details that let you perform various actions. | ||||||||
Save | Saves a new Report record in the Controller database. | ||||||||
Save & New | Saves a new record in the Controller database and redisplays empty Details so that you can create another new record. | ||||||||
Save & View | Saves a new record in the Controller database and continues to display that record. | ||||||||
New | Displays empty (except for default values) Details for creating a new record. | ||||||||
| Saves the Report under a different Title and/or as being visible to different users. | ||||||||
Update |
| ||||||||
Run | Generates the report and displays it on a new tab. (Clicking Run does not save any new data entered for the report.) | ||||||||
Delete |
| ||||||||
Refresh | Refreshes any dynamic data displayed in the Details. |
...
Report output can be created in either of four types, as specified by the 794546364 Type field in the Report Details:
...
By default, entries in List reports are not sorted; you must specify a sort method in the 794546364 Sort By field in the Report Details.
...
If you want to maintain the same reports across several environments (for example: Development, Staging, and Production), you can export Reports from any Controller cluster node and import those same Reports into any Controller cluster node.
Since every Report is 794546364 Visible To a specific user, specific group(s), or Everyone (all users and groups), make sure that for every Report being exported which is visible to a specific user or group(s), that same user or group(s) also exists on the cluster node(s) to which the Report will be imported.
...
You can override some of these system properties in the 794546364 Scheduled Options section of the 794546364 Report Details.
Methods
To run a task that generates an email with an attached report, you can:
...
| Panel |
|---|
Report with name <report-name> and id <report-id> not visible to execution user <execution-user>. |
Bundling and Promotion
Universal Controller supports report promotion. However, if Follow References = false or Promotion Follow Report References = false for a promotion, Any report required by a promoted task must already be available on the target system.
For details on how the Controller resolves tasks that include scheduled Reports, see Preparing Bundles for Promotion / Reports.
...
Table | Table Name | Category | Description | ||||||
|---|---|---|---|---|---|---|---|---|---|
Abort Actions | ops_abort_action | Actions | Contains details about Abort actions. | ||||||
Advanced Criteria | ops_task_email_criteria | Tasks | Contains details about Email Monitor task Advanced Criteria. | ||||||
Advanced Criteria | ops_exec_email_criteria | Task Instances | Contains details about Email Monitor task instances Advanced Criteria. | ||||||
Agent File Monitor Components | ops_trigger_component_fm | Triggers | Contains details about Agent File Monitor components of Composite Triggers. | ||||||
Agent File Monitor Task Instances | ops_exec_file_monitor | All Task Instances | Contains details about Agent File Monitor task instances. | ||||||
Agent File Monitor Tasks | ops_task_file_monitor | Tasks | Contains details about Agent File Monitor tasks. | ||||||
Agent File Monitor Triggers | ops_trigger_fm | All Triggers | Contains details about Agent File Monitor triggers. | ||||||
All Actions | ops_notification | Actions | Contains details about all task actions: Abort Action, Email Notifications, Set Variable, SNMP Notification, and System Operation. | ||||||
All Agent Clusters | ops_agent_cluster | Agent Clusters | Contains details about Agent Clusters. | ||||||
| ops_agent | Agents | Displays a list of Agents Overview. | ||||||
All Components | ops_trigger_component | Triggers | Contains details about all Composite trigger components. | ||||||
All Step Actions | ops_zos_step_action | Step Actions | Contains details about z/OS step actions. | ||||||
| ops_exec | All Task Instances | Task instance activity (running tasks). | ||||||
All Tasks | ops_task | Tasks | Contains details about tasks of every type, along with associated Task Instance information. | ||||||
All Triggers | ops_trigger | All Triggers | Contains details about triggers of every type. | ||||||
Application Control Tasks | ops_task_application_control | Tasks | Contains details about Application Control tasks. | ||||||
Application Control Task Instances | ops_exec_application_control | All Task Instances | Contains details about Application Control task instances. | ||||||
Application Monitor Triggers | ops_trigger_appl_monitor | All Triggers | Contains details about Application Monitor triggers. | ||||||
| ops_application | Shows a list of Application resources. | |||||||
Audits | ops_audit | Security | Contains details of events being written to the Audit history. (Requires ops_audit_view role to run this report.) | ||||||
Business Services | ops_generic_group | Security | Contains details about Business Services. | ||||||
Calendar Custom Days | ops_cal_cust_join | Calendars | Contains details about which Custom Days are associated with which Calendar records. | ||||||
Calendars | ops_calendar | Calendars | Contains details about Calendar records. | ||||||
Cluster Nodes | ops_cluster_node | Provides details about cluster nodes. | |||||||
Composite Triggers | ops_trigger_composite | Triggers | Contains details about Composite trigger records. | ||||||
Credentials | ops_credentials | Login credentials used by the Controller to access remote machines. | |||||||
Cron Triggers | ops_trigger_cron | All Triggers | Contains details about Cron trigger records. | ||||||
| ops_resource_usage | Virtual Resources | Contains details about Virtual resource usage, as displayed in the Currently In Use By tab. | ||||||
Custom Days | ops_custom_day | Calendars | Contains details about defined Custom Days. | ||||||
Database Connections | ops_database_connection | Connections | Contains details about Database Connections defined in the Controller database. | ||||||
Email Connections | ops_email_connection | Connections | Contains details about Email Connections resources. | ||||||
Email Monitor Components | ops_trigger_component_em | Triggers | Contains details about Email Monitor components of Composite Triggers. | ||||||
Email Monitor Task Instances | ops_exec_email_monitor | All Task Instances | Contains details about Email Monitor task instances. | ||||||
Email Monitor Tasks | ops_task_email_monitor | Tasks | Contains details about Email Monitor tasks. | ||||||
Email Monitor Triggers | ops_trigger_em | All Triggers | Contains details about Email Monitor triggers. | ||||||
Email Notifications | ops_email_notification | Actions | Contains details about Email Notifications associated with tasks. | ||||||
Email Task Instances | ops_exec_email | All Task Instances | Contains details about Email task instances. | ||||||
Email Tasks | ops_task_email | Tasks | Contains details about Email tasks. | ||||||
Email Templates | ops_email_template | Contains details about Email templates. | |||||||
| ops_exclusive_order | Mutually Exclusive | Contains any requests to run exclusively by a task instance. | ||||||
File Transfer Task Instances | ops_exec_ftp | All Task Instances | Contains details about File Transfer task instances. | ||||||
File Transfer Tasks | ops_task_ftp | Tasks | Contains details about File Transfer tasks. | ||||||
| ops_trigger_forecast | Contains details about trigger forecasts. | |||||||
| ops_user_grmember | Security | Contains relationship information between Universal Controller User Groups and Universal Controller Users; that is, which Users belong to which Groups. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
Group Roles | ops_group_has_role | Security | Contains relationship information between Universal Controller User Groups and Roles; that is, which Groups have been assigned which Roles. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
Groups | ops_user_group | Security | Contains details about Universal Controller User Groups. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
| ops_history | Contains a history of task activity. | |||||||
| License Instance History | ops_license_exec_history | Contains statistics relating to the number of task instance executions. | |||||||
| IBM i Task Instances | ops_exec_ibmi | Task Instances | Contains details about Linux/Unix task instances. | ||||||
| IBM i Tasks | ops_task_ibmi | Tasks | Contains details about Linux/Unix tasks. | ||||||
Linux/Unix Agent Clusters | ops_unix_agent_cluster | Agent Clusters | Contains details about Linux/Unix agent clusters. | ||||||
Linux/Unix Agents | ops_unix_agent | Agents | Contains details about Linux/Unix agent resources. | ||||||
Linux/Unix Agents In Cluster | ops_unix_agent_cluster_join | Agent Clusters | Shows relationship information between Unix agents and Unix agent clusters; that is, which agents belong to which clusters. | ||||||
Linux/Unix Task Instances | ops_exec_unix | All Task Instances | Contains details about Linux/Unix task instances. | ||||||
Linux/Unix Tasks | ops_task_unix | Tasks | Contains details about Linux/Unix tasks. | ||||||
Local Custom Days | ops_local_custom_day | Calendars | Contains details about defined Local Custom Days. | ||||||
Local Variables | ops_local_variable | Variables | Contains details about task and trigger variables (also called local variables), entered into the Variables tab on a task or trigger record. | ||||||
Manual Task Instances | ops_exec_manual | All Task Instances | Contains details about Manual task instances. | ||||||
Manual Tasks | ops_task_manual | Tasks | Contains details about Manual tasks. | ||||||
Manual Triggers | ops_trigger_manual | All Triggers | Contains Manual trigger records. | ||||||
Mutually Exclusive | ops_task_to_exclusive | Mutually Exclusive | Contains relationship information between tasks and mutually exclusive tasks; that is, which tasks are mutually exclusive with each other. | ||||||
| ops_note | Contains details about Notes attached to Controller records. | |||||||
OMS Servers | ops_oms_server | Connections | Provides details about OMS Servers. | ||||||
Output | ops_exec_output | Task Instances > Other | Contains any output (such as STDOUT) attached to task instances. | ||||||
| ops_resource_order | Virtual Resources | Contains any outstanding requests for a resource by a task instance. | ||||||
PeopleSoft Connections | ops_peoplesoft_connection | Connections | Contains PeopleSoft Connections records. | ||||||
PeopleSoft Parameters | ops_exec_peoplesoft_rt_param | Task Instances > Other | Contains Parameter records associated with PeopleSoft task instances. | ||||||
PeopleSoft Parameters | ops_task_peoplesoft_rt_param | Tasks > Other | Contains Parameter records associated with PeopleSoft tasks. | ||||||
PeopleSoft Task Instances | ops_exec_peoplesoft | All Task Instances | Contains details about PeopleSoft task instances. | ||||||
PeopleSoft Tasks | ops_task_peoplesoft | Tasks | Contains details about PeopleSoft tasks. | ||||||
Permissions | ops_permission | Security | Contains details about Universal Controller Permissions assigned to Universal Controller Users and Groups. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
Recurring Task Instances | ops_exec_recurring | All Task Instances | Contains details about Recurring task instances. | ||||||
Recurring Tasks | ops_task_recurring | Tasks | Contains details about Recurring tasks. | ||||||
Remote File Monitor Task Instances | ops_exec_ftp_file_monitor | All Task Instances | Contains details about Remote File Monitor task instances. | ||||||
Remote File Monitor Tasks | ops_task_ftp_file_monitor | Tasks | Contains details about Remote File Monitor tasks. | ||||||
Restartable Job Steps | ops_exec_zos_jobstepsui | Task Instances > Other | Contains details about restartable job steps in a z/OS task. | ||||||
Restart Criteria | ops_exec_zos_rstrt_criteria | Task Instances > Other | Contain information about z/OS task restart criteria. | ||||||
Restart Criteria | ops_task_zos_rstrt_criteria | Tasks > Other | Contain information about z/OS task restart criteria. | ||||||
SAP Connections | ops_sap_connection | Connections | Contains SAP Connections records. | ||||||
SAP Task Instances | ops_exec_sap | All Task Instances | Contains details about SAP task instances. | ||||||
SAP Tasks | ops_task_sap | Tasks | Contains details about SAP tasks. | ||||||
Scripts | ops_script | Contains Script records. | |||||||
Set Variables | ops_variable_action | Actions | Contains details about Set Variable actions. | ||||||
SNMP Managers | ops_snmp_connection | Connections | Contains SNMP Managers records. | ||||||
SNMP Notifications | ops_snmp_notification | Actions | Contains SNMP notifications defined for Tasks. | ||||||
SQL Task Instances | ops_exec_sql | All Task Instances | Contains details about SQL task instances. | ||||||
SQL Tasks | ops_task_sql | Tasks | Contains details about SQL tasks. | ||||||
Step Conditions | ops_exec_zos_stepcond | Task Instances > Other | Contains details about z/OS task instance step conditions. | ||||||
Step Conditions | ops_task_zos_stepcond | Tasks > Other | Contains details about z/OS task step conditions | ||||||
Stored Procedure Parameters | ops_exec_stored_proc_param | Task Instances > Other | Contains Parameter records associated with Stored Procedure task instances. | ||||||
Stored Procedure Parameters | ops_stored_proc_param | Tasks > Other | Contains Parameter records associated with Stored Procedure tasks. | ||||||
Stored Procedure Task Instances | ops_exec_stored_proc | All Task Instances | Contains details about Stored Procedure task instances. | ||||||
Stored Procedure Tasks | ops_task_stored_proc | Tasks | Contains details about Stored Procedure tasks. | ||||||
System Monitor Task Instances | ops_exec_system_monitor | All Task Instances | Contains details about System Monitor task instances. | ||||||
System Monitors | ops_task_system_monitor | Tasks | Contains details about System Monitor tasks. | ||||||
System Operations | ops_zos_step_action_sysop | Step Actions | Contains details about z/OS System Operation step actions. | ||||||
System Operations | ops_system_operation | Actions | Contains details about System Operation actions. | ||||||
Task Instance Run Criteria | ops_exec_run_criteria | Task Instances > Other | Contains run criteria information for task instances within Workflows. | ||||||
Task Instance Virtual Resources | ops_exec_to_resource | Virtual Resources | Contains relationship information between Virtual resources and task instances; that is, which task instances are assigned to which Virtual Resources. | ||||||
Task Monitor Components | ops_trigger_component_tm | Triggers | Contains details about Task Monitor components of Composite Triggers. | ||||||
Task Monitor Task Instances | ops_exec_monitor | All Task Instances | Contains details about Task Monitor task instances. | ||||||
Task Monitor Tasks | ops_task_monitor | Tasks | Contains details about Task Monitor tasks. | ||||||
Task Monitor Triggers | ops_trigger_tm | All Triggers | Contains details about Task Monitor triggers. | ||||||
Task Run Criteria | ops_task_run_criteria | Tasks > Other | Contains run criteria information for tasks within Workflows. | ||||||
Task Virtual Resources | ops_task_to_resource | Virtual Resources | Contains relationship information between Virtual resources and tasks; that is, which tasks are assigned to which Virtual Resources. | ||||||
Temporary Triggers | ops_trigger_temp | All Triggers | Contains details about Temporary triggers. | ||||||
Time Components | ops_trigger_component_time | Triggers | Contains details about Time components of Composite Triggers. | ||||||
Time Triggers | ops_trigger_time | All Triggers | Contains details about Time triggers. | ||||||
Timer Task Instances | ops_exec_sleep | All Task Instances | Contains details about Timer task instances. | ||||||
Timer Tasks | ops_task_sleep | Tasks | Contains details about Timer tasks. | ||||||
Universal Command Task Instances | ops_exec_indesca | All Task Instances | Contains details about Universal Command task instances. | ||||||
Universal Command Tasks | ops_task_indesca | Tasks | Contains details about Universal Command tasks. | ||||||
Universal Task Instances | ops_exec_universal | All Task Instances | Contains details about Universal task instances. | ||||||
Universal Tasks | ops_task_universal | Tasks | Contains details about Universal tasks. | ||||||
Universal Template Field Choices | ops_unv_tmplt_field_choice | Universal Templates | Contains details about Universal Template Field Choices. (Requires ops_admin, ops_universal_template_admin, or ops_universal_template_view role to run this report.) | ||||||
Universal Template Fields | ops_unv_tmplt_field | Universal Templates | Contains details about Universal Template Fields. (Requires ops_admin, ops_universal_template_admin, or ops_universal_template_view role to run this report.) | ||||||
Universal Templates | ops_unv_tmplt | Universal Templates | Contains details about Universal Templates. (Requires ops_admin, ops_universal_template_admin, or ops_universal_template_view role to run this report.) | ||||||
| ops_user_has_role | Security | Contains details about Users and Roles, including which Users have which Roles. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
| ops_user | Security | Contains details about User records. (Requires ops_admin or ops_user_admin role to run this report.) | ||||||
Variable Monitor Components | ops_trigger_component_vm | Triggers | Contains details about Variable Monitor components of Composite Triggers. | ||||||
Variable Monitor Task Instances | ops_exec_variable_monitor | All Task Instances | Contains details about Variable Monitor task instances. | ||||||
Variable Monitor Tasks | ops_task_variable_monitor | Tasks | Contains details about Variable Monitor tasks. | ||||||
Variable Monitor Triggers | ops_trigger_vm | All Triggers | Contains details about Variable Monitor triggers. | ||||||
Variables | ops_variable | Variables | Contains details about Global variables, entered by selecting Variables from the Navigator. | ||||||
Virtual Resources | ops_virtual_resource | Virtual Resources | Contains details about Virtual resource records. | ||||||
Web Service Task Instances | ops_exec_web_service | All Task Instances | Contains details about Web Service task instances. | ||||||
Web Service Tasks | ops_task_web_service | Tasks | Contains details about Web Service tasks. | ||||||
Widgets | ops_widget | Contains details about Widgets. | |||||||
Windows Agent Clusters | ops_windows_agent_cluster | Agent Clusters | Contains details about Windows agent clusters. | ||||||
Windows Agents | ops_windows_agent | Agents | Contains details about Windows agents. | ||||||
Windows Agents In Cluster | ops_win_agent_cluster_join | Agent Clusters | Shows relationship information between Windows agents and Windows agent clusters; that is, which agents belong to which clusters. | ||||||
Windows Task Instances | ops_exec_windows | All Task Instances | Contains details about Windows task instances. | ||||||
Windows Tasks | ops_task_windows | Tasks | Contains details about Windows tasks. | ||||||
Workflow Task Dependencies | ops_task_workflow_edge | Tasks > Other | Contains information about the conditions specified between tasks within workflows. | ||||||
Workflow Task Instance Dependencies | ops_exec_workflow_edge | Task Instances > Other | Contains information about the conditions specified between task instances within workflows. | ||||||
Workflow Task Instances | ops_exec_workflow | All Task Instances | Contains details about Workflow task instances. | ||||||
| ops_exec_workflow_vertex | Task Instances > Other | Contains relationship information between workflows instances and task instances; that is, which tasks are running in which workflows. | ||||||
| ops_task_workflow_vertex | Tasks > Other | Contains relationship information between tasks and workflows; that is, which tasks are in which workflows. | ||||||
Workflow Tasks | ops_task_workflow | Tasks | Contains details about Workflow tasks. | ||||||
z/OS Agents | ops_zos_agent | Agents | Contains details about z/OS agents. | ||||||
z/OS Monitor Task Instances | ops_exec_zos_monitor | Task Instances | Contains details about Email Monitor task instances. | ||||||
z/OS Monitor Tasks | ops_task_zos_monitor | Tasks | Contains details about Email Monitor tasks. | ||||||
z/OS Task Instances | ops_exec_zos | All Task Instances | Contains details about z/OS task instances. | ||||||
z/OS Tasks | ops_task_zos | Tasks | Contains details about z/OS tasks. |
...