Server Operations

Overview

Universal Controller provides a set of server operations that help you maintain and administer your Controller installation. Many of the operations, as noted, should be run only by Technical Support or upon request by Technical Support.

Running a Server Operation


Step 1

From the Administration navigation pane, select Configuration > Server Operations. The Server Operations list displays.
 

Step 2

Select an operation from the drop-down list and click Run.

Server Operation Completion

When a server operation has been run and completed, the Controller issues an INFO-level log message.

For example:

Server Operation Status

The status for a completed Server Operation is either Success or Failed. The Audit Status field for Server Operations can have one of the following values: Invoked, Failed, or Success.

All Server Operations can fail if the user invoking the Server Operation does not have sufficient permission or if the Server Operation is limited to one execution per node and it is already running.

Most Server Operations will complete successfully; however, if errors occur executing the Server Operation, the Audit Status field is set to Failed, and error messages may be added to the Additional Information field.

The Server Operation duration message will be added to the Audit Additional Information field regardless of the Server Operation status. For example:

Server Operation Timeout

For potentially long running server operations, such as Bulk Import and Bulk Export, we set a request timeout of 30 minutes.

However, some browsers may timeout earlier, regardless. In the case where a server operation has timed out, you will see an error similar to the following in the Console:

In the case of a request timeout, the server operation will continue to run on the server. You will have to confirm completion of the server operation from either the server log, uc.log, or from the Audits list.

View the log for the start and completion of the server operation, as well as any warnings/errors logged in between.

Alternatively, you can view the server operation audit record; however, the log usually provides the most detailed information.

Server Operations Descriptions

The following table describes and, where appropriate, provides links for each server operation.
 

Script

Description and Links

Bulk Export

Exports all current record definitions, without versions, when migrating data to a new Universal Controller deployment.

Bulk Export Activity

Exports all current Activity data from multiple Universal Controller database tables.
 

Note

In order to run this server operation, the Bulk Export Activity Permitted Universal Controller system property must be set to true.

 
If you choose to run this server operation, the following confirmation pop-up displays:
 

Bulk Export Audit

Exports all current Audit records when migrating data to a new Universal Controller deployment.

Bulk Export History

Exports all current History records when migrating data to a new Universal Controller deployment.
 
If you choose to run this server operation, the following confirmation pop-up displays:
 

Bulk Export with Versions

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

Bulk Import

Imports all data from an exported file when migrating data to updated software (see Upgrading Universal Controller from 5.2.0).

Clear Server Cache

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.

Database Information

Displays the following information for the Controller database:

  • Type: MYSQL
  • Database Name: db_name
  • Database Product Name: MySQL
  • Database Product Version: 8.0.11
  • Driver Name: MySQL Connector/J
  • Driver Version: mysql-connector-java-8.0.12 (Revision: 24766725dc6e017025532146d94c6e6c488fb8f1)
  • Configured JDBC URL: jdbc:mysql://hostname:port/
  • Adjusted JDBC URL: jdbc:mysql://hostname:port/db_name?useUnicode=true&serverTimezone=US/Eastern&socketTimeout=1800000
  • Connection Pool: Server (0/3)
  • Connection Pool: Reserved (0/3)
  • Connection Pool: Client (0/5)

Database Table Counts

Displays the following information for Universal Controller database tables:

  • Largest table
  • Number of tables
  • Number of rows
  • Number of rows in each table

See Universal Controller Database Tables, below, for a description of all tables.

Disable Task Instance Business Service Normalization

Disables normalization of Business Service membership for all:

  • New Task Instance and History records.
  • Existing Task Instance and History records if it is still in progress.

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.

Enable Task Instance Business Service Normalization

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.

Note

When deciding on enabling Business Service normalization, it should be noted that there is trade-off between the query performance on Task Instance/History Lists and the added insertion of normalization data at Task Instance/History record creation time.

If the Controller is restarted and the Task Instance Normalize Business Service Membership property is Enabled/Normalizing, the Controller will resume normalization of Business Service membership for all existing Task Instance and History records.

Generate Server UUIDs Cache

For use only by Technical Support personnel or when you are requested to run it by Technical Support.

Health Check

Displays information about the current instance of the Controller.
 

Inspect Events

For use only by Technical Support personnel or when you are requested to run it by Technical Support.

Inspect Universal Events

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.

Inspect Output Message Queue

For use only by Technical Support personnel or when you are requested to run it by Technical Support.

Inspect Subscriptions

For use only by Technical Support personnel or when you are requested to run it by Technical Support.

Inspect Timers

For use only by Technical Support personnel or when you are requested to run it by Technical Support.

LDAP Refresh

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 LDAP Refresh (Asynchronous).

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.

List/Download Logs

Lists (and optionally lets you download) any existing UC log files for the Controller node that this operation is executed on.
 
The list identifies the name, last modification date, size of each log file, and - when you hover over the log file entry on the list - an icon that lets you download that file.
 

 
The icons at the bottom of the list let you perform the following:

  • Download selected log files.
  • Select all log files.
  • Deselect all log files.

(You also can select / deselect all log files by clicking the Name checkbox at the top of the list.)

Load Demonstration Definitions

Loads base demonstration data into your database (for example: workflows, tasks, triggers).

Memory Usage

Displays a summary of Controller memory usage.

Overdue Timers Delete

Deletes any overdue timers, as listed by the Overdue Timers List operation.

Overdue Timers List

Lists any timers that are overdue (normally, no timers should be overdue).

Pause Cluster Node

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 Resume Cluster Node operation.

Purge All Non-Default Users And Groups

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.
 
This server operation will also clear the following fields:

  • Manager field for the Administrator user if it references a non-default user.
  • Manager field for the Administrator Group and/or Everything Group if it references a non-default user.
  • Parent field for the Administrator Group and/or Everything Group if it references a non-default group.

The following is recommended before running this server operation:

  • Disable any triggers that are currently enabled by a non-default user.
  • Unassign the Execution User for any triggers that are currently assigned a non-default user as the Execution User.
  • Complete any active task instances that are currently assigned a non-default user as the Execution User.

Note

To run this server operation, the Purge All Non-Default Users And Groups Permitted Universal Controller System Property must be set to true.

 
If you choose to run this server operation, the following confirmation pop-up displays:
 

Purge History

Purges all records from the History table (ops_history).
 
Any time a task instance goes into an end status (Cancelled, Failed, Skipped, Finished, Success), a copy of it is written to the History table. You can view your History table by selecting Automation Center > Task Instances > History from the navigation pane.
 

Note

If you do not need to keep or back up your task instance history, we recommend that you run this operation periodically; otherwise, make sure you schedule a routine Data Backup/Purge for history by selecting Administration > Data Backup/Purge from the navigation pane. Executing a Data Backup/Purge of an extremely large History table can seriously degrade Controller system performance.

Purge Instances

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.
 

Warning

Running this operation will purge any live data; that is, task instances that have not completed.

Purge Logs and Cache

Sends a request to all active Agents to purge their logs and cache.

Purge Versions

Purges versions of records in excess of the maximum specified by the System Default Maximum Versions Universal Controller system property.

Refresh System Default List Layouts

For Controller upgrades only; resets system defaults list layouts.
 
You may be asked to run this server operation by Technical Support.

Reset All Agent Cluster Task Counts

Resets the current number of tasks currently being run by all Agent clusters to 0 (see Resetting the Current Task Count).

Reset All Agent Task Counts

Resets the current number of tasks currently being run by all Agents to 0 (see Resetting the Current Task Count).

Restart Cluster Node

Stops and restarts the Controller within the running Tomcat server. The Controller is effectively shut down and started up without stopping and starting Tomcat.
 

Note:

Restart Cluster Node will cause a failover to occur if it is executed on the Active node while another node is running as Passive.

Restore System Default List Layouts

Restores all lists to their default layouts.

Resume Cluster Node

Resumes the Controller after it has been paused using the Pause Cluster Node operation, or paused by the Start Server Paused Universal Controller property on startup.

Roll Log

Renames the existing log to a timestamped log and opens a new log file.

Run Garbage Collection

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.

Server Information

Displays the following categories of information about the Universal Controller server:

  • Node
  • License
  • Server Deployment
  • Database Information
  • Memory Information

System Properties

Displays all properties of the operating system on which the Controller is running.
 
You may be asked to run this server operation by Technical Support.

Temporary Property Change

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.

Thread List

Captures information about internal Controller system processes.
 
You may be asked to run this server operation by Technical Support.

Thread List by CPU

Captures information about internal Controller system processes.
 
You may be asked to run this server operation by Technical Support.

Thread Stack Trace

Captures information about internal Controller system processes.
 
You may be asked to run this server operation by Technical Support.

Universal Controller Database Tables

The following table identifies and describes all Universal Controller database tables, which are listed if you run the Database Table Counts server operation, above.

The tables are in alphabetical order according to Table Name.

See Reportable Tables for a list of these database tables that are available for creating Report Details.
 

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.

All Agents

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

Applications

ops_application

Shows a list of Application Resources.

Applications Versions

ops_application_v

Contains details about previous versions of Application resources.

Audits

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.

Event Email

ops_event_email

(For internal use only.)

Event Exec Defined

ops_event_exec_defined

(For internal use only.)

Event Exec Resource Order Filled

ops_event_exec_ordfill

(For internal use only.)

Event Exec Exclusive Order Filled

ops_event_exec_ordfill_ex

(For internal use only.)

Event Exec Propagate State

ops_event_exec_prop_state

(For internal use only.)

Event Exec Skip Child

ops_event_exec_skip_child

(For internal use only.)

Event Exec Start

ops_event_exec_start

(For internal use only.)

Event Exclusive

ops_event_exclusive

(For internal use only.)

Event Resource

ops_event_resource

(For internal use only.)

Event SNMP

ops_event_snmp

(For internal use only.)

Event SQL

ops_event_sql

(For internal use only.)

Event Trigger

ops_event_trigger

(For internal use only.)

Event Trigger Component

ops_event_trigger_comp

For internal use only.)

Event UAC

ops_event_uac

(For internal use only.)

Event UAC Job Abend

ops_event_uac_jobabend

(For internal use only.)

Event UAC Job Complete

ops_event_uac_jobcomp

(For internal use only.)

Event UAC Job End

ops_event_uac_jobend

(For internal use only.)

Event UAC Job Log

ops_event_uac_joblog

(For internal use only.)

Event UAC Job Launch

ops_event_uac_joblaunch

(For internal use only.)

Event UAC Job Start

ops_event_uac_jobstart

(For internal use only.)

Event UAC Job Restart Confirmation

ops_event_uac_rstrt_conf

(For internal use only.)

Event UAC Step End

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 Historyops_exec_license_historyContains 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 Instancesops_exec_recurringContains 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.

Workflow Task Instance Vertices

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.

Job Step Files Data

ops_exec_zos_files

Contains details about jobsteps in a z/OS task.

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.

History

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.

Notes

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.

Permissions

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.

Outstanding Requests

ops_resource_order

Contains any outstanding requests for a Virtual Resource by a task instance.

Currently In Use By

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.

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 Tasksops_task_recurringContains Recurring task records.
Recurring Task Versionsops_task_recurring_vContains 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.

Workflow Tasks Vertices

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.

Forecasts

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

Users

ops_user

Contains details about User records.

Group Members

ops_user_grmember

Contains relationship information between Universal Controller User Groups and Universal Controller Users; that is, which Users belong to which Groups.

Groups

ops_user_group

Contains details about Universal Controller User Groups.

User Roles

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