...
Script | Description and Links | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| Exports all current record definitions, without versions, when migrating data to a new Universal Controller deployment. | |||||||||||
| Exports all current Activity data from multiple Universal Controller database tables.
| |||||||||||
| Exports all current Audit records when migrating data to a new Universal Controller deployment. | |||||||||||
| Exports all current History records when migrating data to a new Universal Controller deployment. | |||||||||||
| Exports all current records along with older (non-current) versions of record definitions when migrating data to updated software (see Upgrading Universal Controller from 5.2.0). | |||||||||||
| Imports all data from an exported file when migrating data to updated software (see Upgrading Universal Controller from 5.2.0). | |||||||||||
| Clears the internal server cache. You can use this operation if you are experiencing unexpected behavior with the Controller system. For example, Technical Support may ask you to first run this operation to clear the server cache, then clear your browser cache. | |||||||||||
| Displays the following information for the Controller database:
| |||||||||||
| Displays the following information for Universal Controller database tables:
See Universal Controller Database Tables, below, for a description of all tables. | |||||||||||
| Disables normalization of Business Service membership for all:
All previously normalized Business Service membership records will not be removed until they qualify for Activity or History purge. Also, the Task Instance Normalize Business Service Membership property will be set to Disabled. | |||||||||||
| Commence normalization of Business Service membership for all existing Task Instance and History records, and begin normalizing Business Service membership for all new Task Instance and History records.
| |||||||||||
| For use only by Technical Support personnel or when you are requested to run it by Technical Support. | |||||||||||
| Displays information about the current instance of the Controller. | |||||||||||
| For use only by Technical Support personnel or when you are requested to run it by Technical Support. | |||||||||||
| Limits the number of events displayed by the Inspect Events server operation. The events will display with the latest events first; that is, ordered by created time descending. Default is 1000. | |||||||||||
| For use only by Technical Support personnel or when you are requested to run it by Technical Support. | |||||||||||
| For use only by Technical Support personnel or when you are requested to run it by Technical Support. | |||||||||||
| For use only by Technical Support personnel or when you are requested to run it by Technical Support. | |||||||||||
| If LDAP is configured for this installation, it refreshes every 24 hours. This server operation forces a refresh. The refresh writes all Controller log entries to the user interface as well as to the Controller log, and the response will not be returned until the process completes. If you estimate the refresh could take a considerable amount of time, we recommend you use 20381848 LDAP Refresh (Asynchronous). | |||||||||||
| If LDAP is configured for this installation, it refreshes every 24 hours. This server operation forces a refresh. The refresh is performed in the background and sends Controller log entries to the Controller log. | |||||||||||
| Lists (and optionally lets you download) any existing UC log files for the Controller node that this operation is executed on.
(You also can select / deselect all log files by clicking the Name checkbox at the top of the list.) | |||||||||||
| Loads base demonstration data into your database (for example: workflows, tasks, triggers). | |||||||||||
| Displays a summary of Controller memory usage. | |||||||||||
| Deletes any overdue timers, as listed by the 20381848 Overdue Timers List operation. | |||||||||||
| Lists any timers that are overdue (normally, no timers should be overdue). | |||||||||||
| Pauses the Controller, which prevents it from processing tasks and events. If an event or task is already running when you run this operation, the event or task will complete. The Controller remains in a paused state until you run the 20381848 Resume Cluster Node operation. | |||||||||||
| Purges all non-default Users and Groups and their associated data. There is one default User: Administrator (ops.admin). There are two default Groups: Administrator Group and Everything Group.
The following is recommended before running this server operation:
| |||||||||||
| Purges all records from the History table (ops_history).
| |||||||||||
| Purges everything in the All Task Instances table (ops_exec), which contains all system activity, including task instances in any status (including end statuses). Records in the All Task Instances table (ops_exec) remain there until they are purged.
| |||||||||||
| Sends a request to all active Agents to purge their logs and cache. | |||||||||||
| Purges versions of records in excess of the maximum specified by the System Default Maximum Versions Universal Controller system property. | |||||||||||
| For Controller upgrades only; resets system defaults list layouts. | |||||||||||
| Resets the current number of tasks currently being run by all Agent clusters to 0 (see Resetting the Current Task Count). | |||||||||||
| Resets the current number of tasks currently being run by all Agents to 0 (see Resetting the Current Task Count). | |||||||||||
| Stops and restarts the Controller within the running Tomcat server. The Controller is effectively shut down and started up without stopping and starting Tomcat.
| |||||||||||
| Restores all lists to their default layouts. | |||||||||||
| Resumes the Controller after it has been paused using the 20381848 Pause Cluster Node operation, or paused by the Start Server Paused Universal Controller property on startup. | |||||||||||
| Renames the existing log to a timestamped log and opens a new log file. | |||||||||||
| Runs the "garbage collector." The gc method suggests that the Java Virtual Machine expend effort toward recycling unused objects in order to make the memory they currently occupy available for quick re-use. When control returns from the method call, the Java Virtual Machine has made a best effort to reclaim space from all discarded objects. | |||||||||||
| Displays the following categories of information about the Universal Controller server:
| |||||||||||
| Displays all properties of the operating system on which the Controller is running. | |||||||||||
| Allows for the temporary setting of specific Universal Controller properties to be used for diagnosing problems. This operation and setting of properties should be performed only under the guidance of Stonebranch support. | |||||||||||
| Captures information about internal Controller system processes. | |||||||||||
| Captures information about internal Controller system processes. | |||||||||||
| Captures information about internal Controller system processes. |
...
The following table identifies and describes all Universal Controller database tables, which are listed if you run the 20381848 Database Table Counts server operation, above.
The tables are in alphabetical order according to Table Name.
...
Table | Table Name | Description | ||||||
---|---|---|---|---|---|---|---|---|
Abort Actions | ops_abort_action | Contains details about Abort actions. | ||||||
Abort Actions Versions | ops_abort_action_v | Contains details about previous versions of Abort actions. New versions of Abort Action records are created when a task record is updated. | ||||||
| ops_agent | Displays a list of Agents Overview. | ||||||
All Agent Clusters | ops_agent_cluster | Contains details about Agent Clusters. | ||||||
All Agent Clusters Versions | ops_agent_cluster_v | Contains details about previous versions of Agent Clusters. | ||||||
All Agents Mapping | ops_agent_mapping | Shows all the agents connected to one or more Promotion Targets (as retrieved using the Refresh Target Agents button). | ||||||
Linux/Unix Agents Mapping | ops_agent_mapping_unix | Shows the mapping specifications between local Linux/Unix agents and Linux/Unix agents on a Promotion Target (as retrieved using the Refresh Target Agents button). | ||||||
Windows Agents Mapping | ops_agent_mapping_windows | Shows the mapping specifications between local Windows agents and Windows agents on a Promotion Target (as retrieved using the Refresh Target Agents button). | ||||||
z/OS Agents Mapping | ops_agent_mapping_zos | Shows the mapping specifications between local z/OS agents and z/OS agents on a Promotion Target (as retrieved using the Refresh Target Agents button). | ||||||
| ops_application | Shows a list of Application Resources. | ||||||
Applications Versions | ops_application_v | Contains details about previous versions of Application resources. | ||||||
| ops_audit | Contains details of events being written to the Audit history. | ||||||
Backups | ops_backup | Contains Backup and Purge records. | ||||||
Bundles | ops_bundle | Contains all Bundles records. | ||||||
Bundles and Agent Clusters | ops_bundle_agent_cluster_join | Shows relationship information between Bundles and Agent Clusters; that is, which agent clusters belong to which bundles. | ||||||
Bundles and Applications | ops_bundle_application_join | Shows relationship information between Bundles and Application resources; that is, which Application resources belong to which bundles. | ||||||
Bundles and Calendars | ops_bundle_calendar_join | Contains relationship information between Bundles and Calendars; that is, which Calendars belong to which Bundles. | ||||||
Bundles and Credentials | ops_bundle_credentials_join | Contains relationship information between Bundles and Credentials; that is, which Credential records belong to which bundles. | ||||||
Bundles and Custom Days | ops_bundle_custom_day_join | Contains relationship information between Custom Days and Bundles; that is, which Custom Days belong to which Bundles. | ||||||
Bundles and Database Connections | ops_bundle_db_cntn_join | Contains information about the relationship between Bundles and Database Connections; that is, which Database Connections belong to which Bundles. | ||||||
Bundles and Email Connections | ops_bundle_email_cntn_join | Contains information about the relationship between Bundles and Email Connections; that is, which Email Connections belong to which Bundles. | ||||||
Bundles and Email Templates | ops_bundle_email_tmplt_join | Contains relationship information between Bundles and Email templates; that is, which Email Templates belong to which Bundles. | ||||||
Bundles and Business Services | ops_bundle_generic_group_join | Contains relationship information between Bundles and Business Services; that is, which Business Services belong to which Bundles. | ||||||
Bundles and PeopleSoft Connections | ops_bundle_ps_cntn_join | Contains relationship information between Bundles and PeopleSoft Connection; that is, which PeopleSoft Connection records are in which Bundles. | ||||||
Bundles and Virtual Resources | ops_bundle_resource_join | Contains relationship information between Bundles and Virtual Resources; that is, which Virtual Resources belong to which Bundles. | ||||||
Bundles and SAP Connections | ops_bundle_sap_cntn_join | Contains relationship information between Bundles and SAP Connection; that is, which SAP Connection records are in which Bundles. | ||||||
Bundles and Scripts | ops_bundle_script_join | Contains relationship information between Bundles and Script; that is, which Scripts belong to which Bundles. | ||||||
Bundles and SNMP Managers | ops_bundle_snmp_cntn_join | Contains relationship information between Bundles and SNMP Manager; that is, which SNMP Managers belong to which Bundles. | ||||||
Promotion Targets | ops_bundle_target | Contains details about Promotion Target records. | ||||||
Bundles and Tasks | ops_bundle_task_join | Contains relationship information between Bundles and Tasks; that is, which Tasks are in which Bundles. | ||||||
Bundles and Triggers | ops_bundle_trigger_join | Contains relationship information between Bundles and Triggers Overview; that is, which Triggers are in which Bundles. | ||||||
Bundles and Variables | ops_bundle_variable_join | Contains relationship information between Bundles and Global variables; that is, which Global variables belong to which Bundles. | ||||||
Calendar Custom Days | ops_cal_cust_join | Contains details about which Custom Days are associated with which Calendar records. | ||||||
Calendar Custom Days Versions | ops_cal_cust_join_v | Contains previous versions of the association between Custom Days and Calendar records. | ||||||
Calendars | ops_calendar | Contains details about Calendar records. | ||||||
Calendars Versions | ops_calendar_v | Contains previous versions of Calendar records. | ||||||
Chart Colors | ops_chart_color | Contains details about colors used in Chart reports. | ||||||
Cluster Lock | ops_cluster_lock | (For internal use only.) | ||||||
Cluster Nodes | ops_cluster_node | Provides details about cluster nodes. | ||||||
Cluster Nodes Notifications | ops_cluster_notification | Contains Email and SNMP notification records associated with the cluster node. | ||||||
Command | ops_command | (For internal use only.) | ||||||
Command Response | ops_command_response | (For internal use only.) | ||||||
Properties | ops_config | Contains Universal Controller System Properties. | ||||||
Connector Notifications | ops_connector_notification | Contains Email Notification and SNMP Notification data associated with Agents and OMS Servers. | ||||||
Counter | ops_count | (For internal use only.) | ||||||
Credentials | ops_credentials | Login credentials used by the Controller to access remote machines. | ||||||
Credentials Versions | ops_credentials_v | Contains previous versions of Credentials records. | ||||||
Custom Days | ops_custom_day | Contains details about defined Custom Days. | ||||||
Custom Days Versions | ops_custom_day_v | Contains previous versions of Custom Days records. | ||||||
Dashboards | ops_dashboard | Contains details about Dashboard Details. | ||||||
Dashboards Portlets | ops_dashboard_portlet | Contains details about the content (Widgets) on the Dashboard Details. | ||||||
Database Connections | ops_database_connection | Contains details about [Database Connections defined in the Controller database. | ||||||
Database Connections Versions | ops_database_connection_v | Contains previous versions of [Database Connections records. | ||||||
Email Notifications | ops_email_cluster_notification | Contains Email Notification records associated with Cluster Nodes. | ||||||
Email Notifications | ops_email_conn_notification | Contains Email Notification-specific data associated with Agents and OMS Servers. | ||||||
Email Connections | ops_email_connection | Contains details about Email Connections resources. | ||||||
Email Connections Versions | ops_email_connection_v | Contains previous versions of Email Connections records. | ||||||
Email Notifications | ops_email_notification | Contains details about Email Notifications associated with tasks. | ||||||
Email Notifications Versions | ops_email_notification_v | Contains previous versions of Email Notifications associated with tasks. Note that a new version is created only when the task is updated. | ||||||
Email Templates | ops_email_template | Contains details about Email templates. | ||||||
Email Templates Versions | ops_email_template_v | Contains previous versions of Email template records. | ||||||
| ops_event_email | (For internal use only.) | ||||||
| ops_event_exec_defined | (For internal use only.) | ||||||
| ops_event_exec_ordfill | (For internal use only.) | ||||||
| ops_event_exec_ordfill_ex | (For internal use only.) | ||||||
| ops_event_exec_prop_state | (For internal use only.) | ||||||
| ops_event_exec_skip_child | (For internal use only.) | ||||||
| ops_event_exec_start | (For internal use only.) | ||||||
| ops_event_exclusive | (For internal use only.) | ||||||
| ops_event_resource | (For internal use only.) | ||||||
| ops_event_snmp | (For internal use only.) | ||||||
| ops_event_sql | (For internal use only.) | ||||||
| ops_event_trigger | (For internal use only.) | ||||||
| ops_event_trigger_comp | For internal use only.) | ||||||
| ops_event_uac | (For internal use only.) | ||||||
| ops_event_uac_jobabend | (For internal use only.) | ||||||
| ops_event_uac_jobcomp | (For internal use only.) | ||||||
| ops_event_uac_jobend | (For internal use only.) | ||||||
| ops_event_uac_joblog | (For internal use only.) | ||||||
| ops_event_uac_joblaunch | (For internal use only.) | ||||||
| ops_event_uac_jobstart | (For internal use only.) | ||||||
| ops_event_uac_rstrt_conf | (For internal use only.) | ||||||
| ops_event_uac_stepend | (For internal use only.) | ||||||
Exclusive Requests | ops_exclusive_order | Contains any outstanding requests by a task instance to run mutually exclusively. | ||||||
| ops_exec | Task instance activity (running tasks). | ||||||
Application Control Task Instances | ops_exec_application_control | Contains details about Application Control task instances. | ||||||
Email Task Instances | ops_exec_email | Contains details about Email task instances. | ||||||
Email Monitor Task Instances | ops_exec_email_monitor | Contains details about Email Monitor task instances. | ||||||
Advanced Criteria | ops_exec_email_criteria | Contains details about Email Monitor task instances Advanced Criteria. | ||||||
Agent File Monitor Instances | ops_exec_file_monitor | Contains details about Agent File Monitor task instances. | ||||||
File Transfer Task Instances | ops_exec_ftp | Contains details about File Transfer task instances. | ||||||
Remote File Monitor Instances | ops_exec_ftp_file_monitor | Contains details about Remote File Monitor task instances. | ||||||
Universal Command Task Instances | ops_exec_indesca | Contains details about Universal Command task instances. | ||||||
License Instance History | ops_exec_license_history | Contains statistics relating to the number of task instance executions. | ||||||
Manual Task Instances | ops_exec_manual | Contains details about Manual task instances. | ||||||
Task Monitor Instances | ops_exec_monitor | Contains details about Task Monitor task instances. | ||||||
Output | ops_exec_output | Contains any output (such as STDOUT) attached to task instances. | ||||||
PeopleSoft Task Instances | ops_exec_peoplesoft | Contains PeopleSoft task instance records. | ||||||
PeopleSoft Task Parameters | ops_exec_peoplesoft_rt_param | Contains Parameter records associated with PeopleSoft task instances. | ||||||
Recurring Task Instances | ops_exec_recurring | Contains details about Recurring task instances. | ||||||
Task Instances Run Criteria | ops_exec_run_criteria | Contains run criteria information for task instances within a Workflow. | ||||||
SAP Task Instances | ops_exec_sap | Contains SAP task instance records. | ||||||
Timer Task Instances | ops_exec_sleep | Contains details about Timer task instances. | ||||||
SQL Task Instances | ops_exec_sql | Contains details about SQL task instances. | ||||||
Stored Procedure Task Instances | ops_exec_stored_proc | Contains details about Stored Procedure task instances. | ||||||
Stored Procedure Task Parameters | ops_exec_stored_proc_param | Contains Parameter records associated with Stored Procedure task instances. | ||||||
System Monitor Task Instances | ops_exec_system_monitor | Contains System Monitor task task instance records. | ||||||
Task Instance Virtual Resources | ops_exec_to_resource | Contains relationship information between Virtual Resources and task instances; that is, which task instances are assigned to which Virtual Resources. | ||||||
Universal Task Instances | ops_exec_universal | Contains details about Universal Task instances. | ||||||
Linux/Unix Task Instances | ops_exec_unix | Contains details about Linux/Unix task instances. | ||||||
Variable Monitor Task Instances | ops_exec_variable_monitor | Contains Variable Monitor task task instance records. | ||||||
Windows Task Instances | ops_exec_windows | Contains details about Windows task instances. | ||||||
Workflow Task Instances | ops_exec_workflow | Contains details about Workflow task instances. | ||||||
Workflow Task Instance Dependencies | ops_exec_workflow_edge | Contains information about the conditions specified between task instances within workflows. | ||||||
| ops_exec_workflow_vertex | Contains relationship information between workflow instances and task instances; that is, which tasks are running in which workflows. | ||||||
z/OS Task Instances | ops_exec_zos | Contains details about z/OS task instances. | ||||||
Restart Confirmations | ops_exec_ zos_confirm | Contains details about any restart confirmations performed on z/OS tasks. | ||||||
| ops_exec_zos_files | |||||||
Restartable Job Steps | ops_exec_zos_jobsteps | Contains historical details about restartable job steps in a z/OS task. | ||||||
Restartable Job Steps | ops_exec_zos_jobstepsui | Contains details about restartable job steps in a z/OS task. | ||||||
Restart Criteria | ops_exec_zos_rstrt_criteria | Contain information about z/OS task restart criteria. | ||||||
Step Conditions | ops_exec_zos_stepcond | Contains details about z/OS task instance step conditions. | ||||||
Externalizable | ops_externalizable | Contains an internal table for events. | ||||||
Business Services | ops_generic_group | Contains details about Business Services. | ||||||
Business Services Versions | ops_generic_group_v | Contains previous versions of Business Service records. | ||||||
Group Roles | ops_group_has_role | Contains relationship information between Universal Controller User Groups and Roles; that is, which Groups have been assigned which Roles. | ||||||
| ops_history | Contains a history of task activity. | ||||||
LDAP | ops_ldap | Identifies where LDAP Settings are stored. | ||||||
Licenses | ops_license | Contains information about the Controller license. | ||||||
List Grid Filters | ops_list_grid_filter | Identifies where persistent filters are stored. | ||||||
List Grid Pin Filters | ops_list_grid_pin_filter | Identifies where pinned filters are stored. | ||||||
List Grid Preferences | ops_list_grid_pref | Contains information about list layouts. | ||||||
Local Custom Days | ops_local_custom_days | Contains details about Local Custom Days. | ||||||
Local Custom Days Versions | ops_local_custom_days_v | Contains previous versions of Local Custom Days. | ||||||
Local Variables | ops_local_variable | Contains details about task and trigger variables (also called local variables), entered into the Variables tab on a task or trigger record. | ||||||
Local Variables Versions | ops_local_variable_v | Contains previous versions of Local variables associated with tasks or triggers. (New version records are created only when a task or trigger is updated. | ||||||
Maps | ops_map | (For internal use only.) | ||||||
Navigator | ops_nav_tree_pref | Contains Navigation Tree Configuration data. | ||||||
| ops_note | Contains details about Notes attached to Controller records. | ||||||
Notes Versions | ops_note_v | Contains previous versions of Notes records. | ||||||
All Actions | ops_notification | Contains details about all task actions: Abort Action, Email Notifications, Set Variable, SNMP Notification, and System Operation. | ||||||
All Actions Versions | ops_notification_v | Contains details about previous versions of all task actions: Abort Action, Email Notifications, Set Variable, SNMP Notification, and System Operation. New versions of Action records are created when a task record is updated. | ||||||
OMS Servers | ops_oms_server | Provides details about OMS Servers. | ||||||
Output Messages | ops_output_msg | (For internal use only.) | ||||||
PeopleSoft Connections | ops_peoplesoft_connection | Contains PeopleSoft Connection records. | ||||||
PeopleSoft Connections Versions | ops_peoplesoft_connection_v | Contains previous versions of PeopleSoft Connection records. | ||||||
| ops_permission | Contains details about Universal Controller Permissions assigned to Universal Controller Users and Universal Controller User Groups. | ||||||
Promotion History | ops_promotion_history | Contains a list of Bundles that have been promoted into the current database. | ||||||
Promotion History Items | ops_promotion_history_item | Contains a list of records that have been promoted into the current database. If a record has been promoted more than once, each version is listed separately. | ||||||
Promotion Schedule | ops_promotion_schedule | Contains a list of Promotion Schedules. | ||||||
Reports | ops_report | Contains information about Controller Report Details. | ||||||
| ops_resource_order | Contains any outstanding requests for a Virtual Resource by a task instance. | ||||||
| ops_resource_usage | Contains details about Virtual resource usage, as displayed in the Currently In Use By tab. | ||||||
SAP Connections | ops_sap_connection | Contains SAP Connection records. | ||||||
SAP Connections Versions | ops_sap_connection_v | Contains previous versions of SAP Connection records. | ||||||
Schemas | ops_schema | Contains version information about database schemas. | ||||||
Scripts | ops_script | Contains Script records. | ||||||
Scripts Versions | ops_script_v | Contains previous versions of Script records. | ||||||
Simulation | ops_simulation | Contains Simulation records. | ||||||
Simulation Output | ops_simulation_output | Contains Simulation output records. | ||||||
SNMP Notifications | ops_snmp_cluster_notification | Contains SNMP notifications defined for Cluster Nodes. | ||||||
SNMP Notifications | ops_snmp_conn_notification | Contains SNMP Notification-specific data associated with Agents and OMS Servers. | ||||||
SNMP Managers | ops_snmp_connection | Contains SNMP Manager records. | ||||||
SNMP Managers Versions | ops_snmp_connection_v | Contains previous versions of SNMP Manager records. | ||||||
SNMP Notifications | ops_snmp_notification | Contains SNMP notifications defined for Tasks. | ||||||
SNMP Notifications Versions | ops_snmp_notification_v | Contains previous versions of SNMP notifications defined for Tasks. (Versions are created only when a task is updated. | ||||||
SQL Results Set | ops_sql_results | Contains output from SQL tasks. | ||||||
SQL Warnings Set | ops_sql_warnings | Contains warnings returned by executed SQL statements. | ||||||
Stored Procedure Parameters | ops_stored_proc_param | Contains Parameter records associated with Stored Procedure tasks. | ||||||
Stored Procedure Parameters Versions | ops_stored_proc_param_v | Contains previous versions of Parameter records associated with Stored Procedure tasks. (Versions are created only when the task is updated. | ||||||
Subscription | ops_subscription | (For internal use only.) | ||||||
System Operations | ops_system_operation | Contains details about System Operation actions. | ||||||
System Operations Versions | ops_system_operation_v | Contains details about previous versions of System Operation actions. (Versions of records are created only when a record is updated.) | ||||||
All Tasks | ops_task | Contains details about tasks of every type, along with associated Task Instance information. | ||||||
Application Control Tasks | ops_task_application_control | Contains details about Application Control tasks. | ||||||
Application Control Task Versions | ops_task_application_control_v | Shows previous versions of Application Control tasks. | ||||||
Email Tasks | ops_task_email | Contains details about Email tasks. | ||||||
Email Task Versions | ops_task_email_v | Contains previous versions of Email task records. | ||||||
Email Monitor Tasks | ops_task_email_monitor | Contains details about Email Monitor tasks. | ||||||
Email Monitor Task Versions | ops_task_email_monitor_v | Contains previous versions of Email Monitor task records. | ||||||
Advanced Criteria | ops_task_email_criteria | Contains details about Email Monitor task Advanced Criteria. | ||||||
Agent File Monitors | ops_task_file_monitor | Contains details about Agent File Monitor tasks. | ||||||
Agent File Monitor Task Versions | ops_task_file_monitor_v | Contains previous versions of Agent File Monitor task records. | ||||||
File Transfer Tasks | ops_task_ftp | Contains details about File Transfer tasks. | ||||||
File Transfer Task Versions | ops_task_ftp_v | Contains previous versions of File transfer task records. | ||||||
Remote File Monitors | ops_task_ftp_file_monitor | Contains details about Remote File Monitor tasks. | ||||||
Remote File Monitor Versions | ops_task_ftp_file_monitor_v | Contains previous versions of Remote File Monitor task records. | ||||||
Universal Command Tasks | ops_task_indesca | Contains details about Universal Command tasks. | ||||||
Universal Command Task Versions | ops_task_indesca_v | Contains previous versions of Universal Command task records. | ||||||
Manual Tasks | ops_task_manual | Contains details about Manual tasks. | ||||||
Manual Task Versions | ops_task_manual_v | Contains previous versions of Manual task records. | ||||||
Task Monitors | ops_task_monitor | Contains details about Task Monitor tasks. | ||||||
Task Monitor Versions | ops_task_monitor_v | Contains previous versions of Task Monitor task records. | ||||||
PeopleSoft Tasks | ops_task_peoplesoft | Contains PeopleSoft task records. | ||||||
PeopleSoft Parameters | ops_task_peoplesoft_rt_param | Contains Parameter records associated with PeopleSoft tasks. | ||||||
PeopleSoft Parameters Versions | ops_task_peoplesoft_rt_param_v | Contains previous versions of Parameter records associated with PeopleSoft tasks. (Versions are created only when the task is updated. | ||||||
PeopleSoft Task Versions | ops_task_peoplesoft_v | Contains previous versions of PeopleSoft task records. | ||||||
Recurring Tasks | ops_task_recurring | Contains Recurring task records. | ||||||
Recurring Task Versions | ops_task_recurring_v | Contains previous versions of Recurring task records. | ||||||
Task Run Criteria | ops_task_run_criteria | Contains run criteria information for tasks within Workflows. | ||||||
Task Run Criteria Versions | ops_task_run_criteria_v | Contains previous versions of run criteria information for tasks within Workflow. (Versions are created only when the Workflow task is updated. | ||||||
SAP Tasks | ops_task_sap | Contains SAP task records. | ||||||
SAP Tasks Versions | ops_task_sap_v | Contains previous versions of SAP task records. | ||||||
Timer Tasks | ops_task_sleep | Contains details about Timer tasks. | ||||||
Timer Task Versions | ops_task_sleep_v | Contains previous versions of Timer tasks records. | ||||||
SQL Tasks | ops_task_sql | Contains details about SQL tasks. | ||||||
SQL Task Versions | ops_task_sql_v | Contains previous versions of SQL tasks records. | ||||||
Mutually Exclusive | ops_task_to_exclusive | Contains relationship information between tasks and mutually exclusive tasks; that is, which tasks are mutually exclusive with each other. | ||||||
Mutually Exclusive Versions | ops_task_to_exclusive_v | Contains previous versions of relationship information between tasks and mutually exclusive tasks. | ||||||
Stored Procedure Tasks | ops_task_stored_proc | Contains details about Stored Procedure tasks. | ||||||
Stored Procedure Tasks Versions | ops_task_stored_proc_v | Contains previous versions of Stored Procedure tasks records. | ||||||
System Monitors | ops_task_system_monitor | Contains System Monitor task records. | ||||||
System Monitor Versions | ops_task_system_monitor_v | Contains previous versions of System Monitor task records. | ||||||
Task Virtual Resources | ops_task_to_resource | Contains relationship information between Virtual Resources and tasks; that is, which tasks are assigned to which Virtual Resources. | ||||||
Task Virtual Resources Versions | ops_task_to_resource_v | Contains previous versions of relationship information between Virtual Resources and tasks. | ||||||
Universal Tasks | ops_task_universal | Contains details about Universal tasks. | ||||||
Universal Task Versions | ops_task_universal_v | Contains previous versions of Universal task records. | ||||||
Linux/Unix Tasks | ops_task_unix | Contains details about Linux/Unix tasks. | ||||||
Linux/Unix Task Versions | ops_task_unix_v | Contains previous versions of Linux/Unix task records. | ||||||
All Tasks Versions | ops_task_v | Contains previous versions of all task records. | ||||||
Variable Monitor Tasks | ops_task_variable_monitor | Contains details about Variable Monitor tasks. | ||||||
Variable Monitor Task Versions | ops_task_variable_monitor_v | Contains previous versions of Variable Monitor task records. | ||||||
Windows Tasks | ops_task_windows | Contains details about Windows tasks. | ||||||
Windows Task Versions | ops_task_windows_v | Contains previous versions of Windows task records. | ||||||
Workflow Tasks | ops_task_workflow | Contains details about Workflow tasks. | ||||||
Task Workflow Dependencies | ops_task_workflow_edge | Contains information about the conditions specified between tasks in workflows. | ||||||
Workflow Task Edges | ops_task_workflow_edge_v | Contains previous versions of information about the conditions specified among tasks in workflows. (New versions of records are created only when the Workflow task is updated. | ||||||
Workflow Task Versions | ops_task_workflow_v | Contains previous versions of workflow task records. | ||||||
| ops_task_workflow_vertex | Contains relationship information between tasks and workflows; that is, which tasks are in which workflows. | ||||||
Workflow Tasks Vertices Versions | ops_task_workflow_vertex_v | Contains previous versions of the relationship between tasks and workflows. (Versions are created only when the workflow task is updated. | ||||||
z/OS Tasks | ops_task_zos | Contains details about z/OS tasks. | ||||||
Restart Criteria | ops_task_zos_rstrt_criteria | Contain information about z/OS task restart criteria. | ||||||
Restart Criteria | ops_task_zos_rstrt_criteria_v | Contains previous versions of z/OS task restart criteria. | ||||||
Step Conditions | ops_task_zos_stepcond | Contains details about z/OS task step conditions | ||||||
Step Conditions | ops_task_zos_stepcond_v | Contains previous versions of z/OS task step conditions | ||||||
z/OS Task Versions | ops_task_zos_v | Contains previous versions of z/OS task records. | ||||||
Time Zones | ops_time_zone | Stores information on time zones. | ||||||
Timer | ops_timer | (For internal use only.) | ||||||
All Triggers | ops_trigger | Contains details about triggers of every type. | ||||||
Application Monitor Triggers | ops_trigger_appl_monitor | Contains details about Application Monitor triggers. | ||||||
Application Monitor Triggers Versions | ops_trigger_appl_monitor_v | Contains details about previous versions of Application Monitor triggers. | ||||||
All Components | ops_trigger_component | Contains details about all Composite trigger components. | ||||||
Email Monitor Components | ops_trigger_component_em | Contains details about Email Monitor components of Composite Triggers. | ||||||
Email Monitor Components | ops_trigger_component_em_v | Contains details about previous versions of Email Monitor components of Composite Triggers. | ||||||
File Monitor Components | ops_trigger_component_fm | Contains details about File Monitor components of Composite Triggers. | ||||||
File Monitor Components | ops_trigger_component_fm_v | Contains details about previous versions of File Monitor components of Composite Triggers. | ||||||
Time Components | ops_trigger_component_time | Contains details about Time components of Composite Triggers. | ||||||
Time Components | ops_trigger_component_time_v | Contains details about previous versions of Time components of Composite Triggers. | ||||||
Variable Monitor Components | ops_trigger_component_vm | Contains details about Variable Monitor components of Composite Triggers. | ||||||
Variable Monitor Components | ops_trigger_component_vm_v | Contains details about previous versions of Variable Monitor components of Composite Triggers. | ||||||
Task Monitor Components | ops_trigger_component_tm | Contains details about Task Monitor components of Composite Triggers. | ||||||
Task Monitor Components | ops_trigger_component_tm_v | Contains details about previous versions of Task Monitor components of Composite Triggers. | ||||||
All Components | ops_trigger_component_v | Contains details about previous versions of all Composite trigger components. | ||||||
Composite Triggers | ops_trigger_composite | Contains details about Composite trigger records. | ||||||
Composite Triggers | ops_trigger_composite_v | Contains details about previous versions of Composite trigger records. | ||||||
Cron Triggers | ops_trigger_cron | Contains details about Cron trigger records. | ||||||
Cron Trigger Versions | ops_trigger_cron_v | Contains previous versions of Cron trigger records. | ||||||
Email Monitor Triggers | ops_trigger_em | Contains details about Email Monitor trigger records. | ||||||
Email Monitor Trigger Versions | ops_trigger_em_v | Contains previous versions of Email Monitor trigger records. | ||||||
File Monitor Triggers | ops_trigger_fm | Contains details about File Monitor triggers. | ||||||
File Monitor Triggers Versions | ops_trigger_fm_v | Contains previous versions of File Monitor trigger records. | ||||||
| ops_trigger_forecast | Contains details about trigger forecasts. | ||||||
Manual Triggers | ops_trigger_manual | Contains Manual trigger records. | ||||||
Manual Trigger Versions | ops_trigger_manual_v | Contains previous versions of Manual trigger records. | ||||||
Temporary Triggers | ops_trigger_temp | Contains details about Temporary triggers. | ||||||
Temporary Triggers Versions | ops_trigger_temp_v | Contains previous versions of Temporary trigger records. | ||||||
Time Triggers | ops_trigger_time | Contains details about Time triggers. | ||||||
Time Triggers Versions | ops_trigger_time_v | Contains previous versions of Time trigger records. | ||||||
Task Monitor Triggers | ops_trigger_tm | Contains details about Task Monitor triggers. | ||||||
Task Monitor Triggers Versions | ops_trigger_tm_v | Contains previous versions of Task Monitor trigger records. | ||||||
All Triggers Versions | ops_trigger_v | Contains previous versions of Trigger records. | ||||||
Variable Monitor Triggers | ops_trigger_vm | Contains details about Variable Monitor triggers. | ||||||
Variable Monitor Triggers Versions | ops_trigger_vm_v | Contains previous versions of Variable Monitor trigger records. | ||||||
Linux/Unix Agents | ops_unix_agent | Contains details about Linux/Unix agent resources. | ||||||
Linux/Unix Agent Clusters | ops_unix_agent_cluster | Contains details about Linux/Unix agent clusters. | ||||||
Linux/Unix Agents In Cluster | ops_unix_agent_cluster_join | Shows relationship information between Unix agents and Unix agent clusters, that is, which agents belong to which clusters. | ||||||
Linux/Unix Agents In Cluster Versions | ops_unix_agent_cluster_join_v | Shows previous versions of relationship information between Unix agents and Unix agent clusters. | ||||||
Linux/Unix Agent Clusters Versions | ops_unix_agent_cluster_v | Contains previous versions of Linux/Unix cluster records. | ||||||
Universal Templates | ops_unv_tmplt | Contains details about Universal Templates. | ||||||
Universal Template Fields | ops_unv_tmplt_field | Contains details about Universal Template Fields. | ||||||
Universal Template Field Choice Values | ops_unv_tmplt_field_choice | Contains details about Universal Templates. (Requires ops_admin or ops_universal_template_admin role.) | ||||||
| ops_user | Contains details about User records. | ||||||
| ops_user_grmember | Contains relationship information between Universal Controller User Groups and Universal Controller Users; that is, which Users belong to which Groups. | ||||||
| ops_user_group | Contains details about Universal Controller User Groups. | ||||||
| ops_user_has_role | Contains details about Users and Roles, including which Users have which Roles. | ||||||
User Preferences | ops_user_preference | Contains information about Universal Controller User Preferences. | ||||||
User Roles | ops_user_role | Contains information about available user roles. | ||||||
User Roles Contains | ops_user_role_contains | Contains information about roles that comprise parent roles user roles. | ||||||
User Tokens | ops_user_token | Contains information about user sessions. | ||||||
Variables | ops_variable | Contains details about Global variables, entered by selecting Variables from the Navigation pane. | ||||||
Set Variables | ops_variable_action | Contains details about Set Variable actions. | ||||||
Set Variables | ops_variable_action_v | Contains previous versions of Set Variable actions. | ||||||
Variables Versions | ops_variable_v | Contains previous versions of Global variables. | ||||||
Virtual Resources | ops_virtual_resource | Contains details about Virtual resource records. | ||||||
Virtual Resources Versions | ops_virtual_resource_v | Contains previous versions of Virtual resources. | ||||||
Widgets | ops_widget | Contains details about all Widgets. | ||||||
Widgets Activity | ops_widget_activity | Contains details about Activity Widgets. | ||||||
Widgets Report | ops_widget_report | Contains details about Report Widgets. | ||||||
Widgets System | ops_widget_system | Contains details about System Widgets. | ||||||
Windows Agents In Cluster | ops_win_agent_cluster_join | Shows relationship information between Windows agents and Windows agent clusters, that is, which agents belong to which clusters. | ||||||
Windows Agents In Cluster Versions | ops_win_agent_cluster_join_v | Shows previous versions of relationship information between Windows agents and Windows agent clusters. | ||||||
Windows Agents | ops_windows_agent | Contains details about Windows agents. | ||||||
Windows Agent Clusters | ops_windows_agent_cluster | Contains details about Windows agent clusters. | ||||||
Windows Agent Clusters Versions | ops_windows_agent_cluster_v | Contains previous versions of Windows Agent Cluster records. | ||||||
z/OS Agents | ops_zos_agent | Contains details about z/OS agents. | ||||||
All Step Actions | ops_zos_step_action | Contains details about z/OS step actions. | ||||||
System Operations | ops_zos_step_action_sysop | Contains details about z/OS System Operation step actions. | ||||||
System Operations Versions | ops_zos_step_action_sysop_v | Contains details about previous versions of z/OS System Operation step actions. (Versions are created only when a record is updated.) | ||||||
Step Actions | ops_zos_step_action_v | Contains previous versions of z/OS step actions. (Versions are created only when a record is updated.) |
...