Kintana Script : List Environment Table

Purpose

This script will get you a hard copy list of the environment table.

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 Environment Table

select ee.enabled_flag, ee.environment_name, ee.client_name, ee.description
from KENV_ENVIRONMENTS ee
order by ee.description

ENABLED_FLAG ENVIRONMENT_NAME  CLIENT_NAME  DESCRIPTION
------------ ----------------- ------------ ---------------------------------------
Y            DEV NSWS1         DEV_NSWS1    DEV  Web server
Y            DEV BLD_DP2       DEV_DP2      DEV  Dataplot Build Application server
Y            QA DP1_QA         QA_DP1       QA   DataPlot Application Server
Y            QA DP2_QA         QA_DP2       QA   DataPlot Application Server
Y            QA QA_NSWS1       QA_NSWS1     QA   Web Server (Non Secure)

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)