Kintana Script : Workflow Step Security Groups

Purpose

Useful to determine whether you are using security groups consistently to control workflow step execution.

Tested

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

Usage

Paste the script into SQL Runner

Omit the comment, spool, and linesize statements unless you're using a PL-SQL editor. SQL Runner only supports select statements and you'll get a KNTA-10648 error. If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

-- List Worflow Step Security Groups
spool c:\workflow_step_security_groups_yyyymmdd.txt
set linesize 1000

select ww.workflow_name,
       wws.sort_order "Step No",
       wws.step_name,
       nsg.security_group_name
from KWFL_WORKFLOWS ww,
     KWFL_WORKFLOW_STEPS wws,
     KWFL_WORKFLOW_STEP_SECURITY wwss,
     KNTA_SECURITY_GROUPS nsg
where
-- limit by workflow
      ( ww.workflow_name = 'My Workflow 1' or
         ww.workflow_name = 'My Workflow 2'
      )
-- limit by security group
-- and nsg.security_group_name = 'My Security Group"
and ww.workflow_id = wws.workflow_id
and wws.workflow_step_id = wwss.workflow_step_id
and wwss.security_type_code = 'SECURITY_GROUP'
and wwss.security_group_id = nsg.security_group_id
order by ww.workflow_name, wws.sort_order, nsg.security_group_name
-- order by nsg.security_group_name, ww.workflow_name, wws.sort_order
 

spool off

WORKFLOW_NAME,       Step No   STEP_NAME       SECURITY_GROUP_NAME
My Workflow 1         22       Goods Inwards   Inspection NOD
My Workflow 1         23       Restocking      Stock Managers
My Workflow 2         54       Bin Control     Audit Control
...

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 (79 Kb)