Kintana Script : Security Groups Controlling Access to Specified Environments

Purpose

A good security policy closely controls the groups that can migrate into the important environments - particularly prod!

This script will help you verify that your security group policy for migrations into destination environments in being followed.

It lists the security groups set on steps migrating into specified environments.

Tested

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

Usage

Paste the script into Toad or SQL Runner

select ww.workflow_name,
      wws.step_name,
      ee.environment_name,
      nsg.security_group_name
from KWFL_WORKFLOW_STEP_SECURITY wwss,
     KWFL_WORKFLOW_STEPS wws,
     KWFL_WORKFLOWS ww,
     KENV_ENVIRONMENTS ee,
     KNTA_SECURITY_GROUPS nsg
where wwss.security_group_id = nsg.security_group_id
  and wws.dest_environment_id = ee.environment_id
  and wwss.workflow_step_id = wws.workflow_step_id
  and wws.workflow_id = ww.workflow_id
  and ww.enabled_flag = 'Y'
  and wwss.security_type_code = 'SECURITY_GROUP'
  and ee.environment_name in ('qa', 'test', 'prod')
  order by ww.workflow_name, wws.step_name, ee.environment_name, nsg.security_group_name

Download

KintanaScripts.zip (58 Kb)