SQL Queries - CAST Management Base - How to retrieve external program name

Purpose of Query

This page provides a query to run on the management base that will provide information on the names of the external programs used in the analysis (both before and after analysis).

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS✅

Query for CSS

SELECT ProgName
FROM   CMS_TOOL_ProgBefore

UNION ALL

SELECT ProgName
FROM   CMS_TOOL_ProgAfter

Query result example

“C:\Windows\hh.exe”

Query result interpretation

The result is the list of external programs used in the analysis (both before and after analysis)

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages