SQL Queries - CAST Knowledge Base - Queries on source code - How to check if source code is attached in CAST KB

Purpose of Query
 This page provides a query to be run on Knowledge Base to see if the source code is attached in CAST Knowledge base
Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)

After running the Snapshot, the Table DSS_CODE_SOURCES is populated which contains information about the source.

Below query can be used to find the same:-

Query
 Select * from DSS_CODE_SOURCES where SOURCE_PATH like '%<root_path>%'
Notes/comments
 If the above query returns rows then source code is attached and if it does not returns then source code is not attached / not properly analyzed
Query result example

Related Pages