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 | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS2 | ✅ |
| CSS1 | ✅ |
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