Share this page

# MPKG_PENDING_PACKAGES

Used to create a report that shows the volume of open packages for any given workflow in Deployment Management.

Provides a quick snapshot of ongoing package processing work. It shows:

- a summary of packages currently open for a specific Deployment Management workflow (for example, total number or average age)

- information on how many packages have been opened and closed in the current week and current month

- priority of the packages

  Priority is usually the most important breakdown of load information. Data is grouped into three priority groupings: P1, P2, and P3. These groupings map to the three highest–priority levels defined.

MPKG_PENDING_PACKAGES is aggregated across all packages.

Sample

A project manager has deployments running through three separate workflows in a current project. The manager needs a report that will show current work volume in each of these workflows, to help prioritize work and identify bottlenecks. If the three workflows are named MFG prod deployment, FIN prod deployment, and prod backup, the following SQL query can be used for a report:

    SELECT workflow              Workflow,
           open_packages         Open_Pkgs,
           avg_age_open_packages Avg Age,
           p1_open_packages      P1 Open Pkgs,
           p2_open_packages      P2 Open Pkgs
    FROM   mpkg_pending_packages
    WHERE  workflow IN
           ('MFG prod deployment',
           'FIN prod deployment',
           'prod backup');

Results

                                        P1    P2
                           Open  Avg  Open  Open
    WORKFLOW               Pkgs  Age  Pkgs  Pkgs
    --------------------- ----- ---- ----- -----
    MFG prod deployment      11    9     3     8
    FIN prod deployment      39   16    14    25
    prod backup               6   54     5     1

This view ignores packages that have not been submitted.

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: