Kintana Script : List Environments In Use By Workflows

Purpose

This list shows which servers (ENVIRONMENT_NAME) are in use by which workflows.

Before deleting a server's environment record check that it is not is use by a workflow! If you delete an environment record that is use by a workflow the workflow will stop working!

If it is, then click on 'Configuration' 'Workflows' to open the workflow. Open the graphical 'Layout'.

The server is referenced in the STEP_NAME specified in the listing. As a result of the inspection you may decide to delete or change the workflow, or just disable the environment record.

Tested

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

Usage

Paste the following script into SQL Runner

Omit the comment unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

-- List Environments In Use By Workflows

select ww.workflow_name,
       wws.step_name,
       ee.environment_name, ee.description
from KENV_ENVIRONMENTS ee,
     KWFL_WORKFLOWS ww,
     KWFL_WORKFLOW_STEPS wws
where ( wws.source_environment_id != 0 or wws.dest_environment_id != 0 )
      and wws.workflow_id = ww.workflow_id
and ( wws.source_environment_id = ee.environment_id or
      wws.dest_environment_id   = ee.environment_id )
-- and ee.environment_name = 'MYENVIRONMENT'
order by ee.environment_name

WORKFLOW_NAME  STEP_NAME        ENV_NAME    DESCRIPTION
-------------- ---------------- ----------- ----------------------
C++ Lib Build  Execute          DEV Gandalf DEV Application server
Dataplot       Copy             DEV Gandalf DEV Application server
RemScan        Migrate to PROD  DEV Frodo   DEV Application server

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste.

Download

KintanaScripts.zip (64 Kb)