Kintana Script : Workflows that migrate to a specified environment

Purpose

The script identifies Deliver workflows with steps that migrate into a specified environment.

Useful when you're doing a security audit and need to identify workflows that migrate into production.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

select distinct ww.workflow_name
       -- ,wws.sort_order "Step#"
       -- wws.step_name,
       -- ee.environment_name
from KWFL_WORKFLOW_STEPS wws,
     KWFL_WORKFLOWS ww,
     KENV_ENVIRONMENTS ee
where wws.workflow_id = ww.workflow_id
  and ww.enabled_flag = 'Y'
  and wws.enabled_flag = 'Y'
  and ee.environment_id = wws.dest_environment_id
  and ww.product_scope_code = 'AI'
  --  and ee.environment_name = 'PROD'
order by ww.workflow_name
  --, wws.sort_order

Download

KintanaScripts.zip (79 Kb)