SQL Queries - CAST Management Base - How to check for overlapping user-defined source folders by technology

Purpose of Query

This query when ran on the CAST management base will provide the list of user-defined source folders for a given technology, ordered by file types in alphabetical order

You just have to compare the folders and see if there are some overlap on the others.

**Please note that this query will have empty results if no source include folder were manually configured by the user.**In this case you should compare the rootpath of the analysis units using the following query instead : SQL Queries - CAST Management Base - How to check for overlapping analysis units by technology

A pre-requisite is to identify the table you will use, depending on the technology :

In management base, for each technology you have one table containing the analysis units.

Their names are CMS__ANALYSIS.

For instance, for Java you have table CMS_J2EE_ANALYSIS.

For .Net you have CMS_NET_ANALYSIS.

For C++ you have CMS_CPP_ANALYSIS.

Applicable CAST Version

Release	Yes/No
8.3.x	✅

Applicable RDBMS

RDBMS	Yes/No
CSS	✅

Query for CSS, Oracle, and SQL server

SELECT cja.object_name AS AnalysisUnitName, 
       CCS.path, 
       CO.symbol      AS CustomIncludePath 
FROM   cms_objectlinks CO 
       JOIN cms_code_sourcefolder CCS 
         ON CCS.object_id = CO.callee_id 
       JOIN cms_j2ee_analysis cja 
         ON cja.object_id = CO.caller_id 
ORDER  BY CO.symbol, 
          CCS.path

Query result example

“MyAppMobileWeb”;“S:\Sources\MyApp\Analyzed\DSS\MF_code\app”;“clientFiles”

“MyAppMobileWeb”;“S:\Sources\MyApp\Analyzed\DSS\MF_code\app\js”;“clientFiles”

“MyWorldShopDataTypes”;“S:\Sources\MyApp\Analyzed\XXXX\MyWorldShopDataTypes”;“javaFiles”

“XXXXWebAppStruts1.1Analyzed”;“S:\Sources\MyApp\Analyzed\XXXX\XXXXWebApp\src”;“javaFiles”

“XXXXWebAppStruts1.1Analyzed”;“S:\Sources\MyApp\Analyzed\XXXX\XXXXWebApp”;“propertyFiles”

“main3”;“S:\Sources\MyApp\Analyzed\SL\sl_core\main”;“propertyFiles”

“main1”;“S:\Sources\MyApp\Analyzed\SL\sl_core\main”;“propertyFiles”

“main2”;“S:\Sources\MyApp\Analyzed\SL\sl_core\main”;“propertyFiles”

“LoggingServerHelperUtil”;“S:\Sources\MyApp\Analyzed\XXXX\LoggingServerHelperUtil”;“xmlFiles”

“XXXXWebAppStruts1.1Analyzed”;“S:\Sources\MyApp\Analyzed\XXXX\XXXXWebApp”;“xmlFiles”

“XXXXWebApp”;“S:\Sources\MyApp\Analyzed\XXXX\XXXXWebApp\WebContent”;“xmlFiles”

Query result interpretation

Category “clientFiles” : you see that the two source folders are overlapping, since “S:\Sources\MyApp\Analyzed\DSS\MF_code\app\js” is incuded in “S:\Sources\MyApp\Analyzed\DSS\MF_code\app”
Category “javaFiles” : no overlap
Category “propertyFiles” : you see that “main1”, main2" and “main3” are overlapping, since they are pointing to the same folder : “S:\Sources\MyApp\Analyzed\SL\sl_core\main”
Category “xmlFiles” : you see that two folders are overlapping since they are pointing to the same folder : “S:\Sources\MyApp\Analyzed\XXXX\XXXXWebApp”

Notes/comments