Kintana Script : List Commands for Request Types

Purpose

The script lists command scripts in use by all or a specific request type. It can be used to get your scripts out of Kintana into a flat file that makes it possible for you to:

Search your scripts by keyword e.g.: for objects using particular variables

Review your scripts en-mass for consistency with standards. You can edit the scripts in an external editor, then re-import them to Kintana

Archive 'snaphots' of your script stock into your version control system so you can compare a current Kintana script with a previous version

The listing can be copied to a flat file or excel spreadsheet.

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 Command code for request types

select crt.request_type_name "Request Type",
       nc.command_seq        "Cmd#",
       nc.command_name       "Command Name",
       nc.enabled_flag       "Enabled",
       nc.condition          "Condition",
       nc.timeout_seconds    "Timeout",
       ncs.command
from  KNTA_COMMANDS nc,
      KNTA_COMMAND_STEPS ncs,
      KNTA_ENTITIES ne,
      KCRT_REQUEST_TYPES crt
where nc.parent_entity_id = ne.entity_id
  and ne.entity_name = 'Request Type'
  and nc.parent_id = crt.request_type_id
  -- limit to one request type
  and crt.request_type_name = 'my Request'
  and nc.command_id = ncs.command_id
  order by nc.command_seq

Request Type Cmd#  Command Name     Enabled Condition                Timeout COMMAND
----------------   ------------     ---     ----------------------   ----    ---------
Inventory       1  Set defaults     Y       [REQUEST_TYPE] != ...    90      ksc_set ...
Inventory       2  Check Bin Group  Y       [REQUEST_TYPE] = ...     90      cbg([...
Inventory       3  Set Bin Group    Y       [REQUEST_TYPE] = ...     90      ksc-store ...

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)