Kintana Script : Deployments, Patches, Upgrade Logs

Purpose

You need to know the patch level you're on to file service requests.

You may also need to check the current versions of the components you have installed.

The upgrade logs should always be checked after an upgrade for problems with the installation.

Tested

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

Usage

Paste the script into Toad or SQL Runner

-- list deployments

select * from KINS_DEPLOYMENTS
Output : DEPLOYMENT_ID  VERSION DEPLOYED_DATE          DESCRIPTION
         OracleApps     550     2007-12-20 20:31:05.0  Oracle_Apps_Extension
         OracleTech     550     2007-12-20 20:32:10.0  OracleTech_Extension
         PL23           550     2007-12-20 20:35:30.0  Patch_Level_23
         BestPractices  550     2007-12-20 20 27:36.0  Mercury_ITG_Best_Practices

-- list patches

select * from KINS_PATCHES
Output : PATCH_NUMBER|VERSION|PATCH_DATE|DESCRIPTION

-- list the logs output by the upgrade scripts

select * from KINS_UPGRADE_LOGS
Output : UPGRADE_LOG_ID CREATION_DATE CREATED_BY UPGRADE_RUN_ID VERSION_NUMBER PATCH_NUMBER SOURCE MESSAGE_TYPE MESSAGE

select * from KNTA_ARCHIVES

Download

KintanaScripts.zip (64 Kb)