Kintana Script : List Report Commands

Purpose

Used to list all Report command scripts in use by enabled objects 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 report types

SELECT drt.report_type_name,
       nc.command_seq,
       nc.command_name,
       nc.enabled_flag,
       nc.condition,
       ncs.step_seq,
       ncs.command
FROM KNTA_REPORT_TYPES drt,
     KNTA_COMMANDS nc,
     KNTA_COMMAND_STEPS ncs
WHERE drt.enabled_flag = 'Y'
  AND drt.report_type_id = nc.parent_id
  AND nc.command_id = ncs.command_id
ORDER BY drt.report_type_name, nc.command_seq, ncs.step_seq

REPORT_TYPE_NAME CMD  COMMAND_NAME             ENABLED CONDITION STEP  COMMAND
                 SEQ                           FLAG              SEQ
---------------- ---  ----------------------   ----    --------- ----  -------
Inventory Status   1  Show Parameters          Y                   1   # Updated:
Inventory Status   1  Show Parameters          Y                   2   # 02/05/2005 Dave Goodall
Inventory Status   1  Show Parameters          Y                   3
Inventory Status   1  Show Parameters          Y                   4   # Parameters
Inventory Status   1  Show Parameters          Y                   5   # SKU Codes

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)