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

Created by John McMahon on Feb 11, 2022
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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS


RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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