Share this page

# MPKGL_PENDING_DEPLOYMENT_BY_ENV/APP/OT

Summarizes the number of open packages and package lines that are currently pending deployment into environments.

The deployment information is broken down into a different category for each view:

- To see the distribution of the number of objects pending deployment across environments, use the view MPKGL_PENDING_DEPLOYMENT_BY_ENV.

- To see the same information distributed across applications, use MPKGL_PENDING_DEPLOYMENT_BY_APP.

- To see the same deployment information distributed across object types, use MPKGL_PENDING_DEPLOYMENT_BY_OT.

Sample

To obtain a quick look at the volume of deployments queued up at each environment defined in the system (for those with one or more pending deployments):

    SELECT environment,
           total_count,
           unique_pkgs,
           unique_pkg_lines,
           unique_obj_types
    FROM   mpkgl_pending_deployment_by_env;

The internal ID columns for Environments and Object Types (ENVIRONMENT_ID and OBJECT_TYPE_ID) can be used to link this view with other relevant views (for example, MPKGL_PACKAGE_LINES) to provide additional information in a report built from these views.

This view will not capture processes where the package line is waiting at an approval step that fires an immediate execution step.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: