SQL Queries - CAST Management Base - How to check for analysis units created more than once for different paths

Purpose of Query

This query when ran on the CAST management base will provide the list of analysis units created more than once having different project file paths.

Applicable CAST Version

ReleaseYes/No
8.3.x✅

Applicable RDBMS

RDBMSYes/No
CSS4✅
CSS3✅

Query for JAVA (CSS, Oracle, SQL Server)

with DuplicateNames as
(
select mau.Object_Name
  from CMS_PORTF_Module cpm
  join CMS_PORTF_ObjectFilter cpof
    on cpof.Module_Id = cpm.Object_Id
  join MAINT_AnalysisUnits mau
    on mau.Object_Name = cpm.Object_Name
 group by mau.Object_Name
 having count(1) > 1
)
select *
  from DuplicateNames dn
  join MAINT_AnalysisUnits mau
    on mau.Object_Name = dn.Object_Name;

Query result example

'DataGridFilterLibrary',95656,'DataGridFilterLibrary',69617,'.NET',74709,,1  
'DataGridFilterLibrary',95729,'DataGridFilterLibrary',69617,'.NET',74709,,1  
'DataGridFilterLibrary',95749,'DataGridFilterLibrary',69617,'.NET',74709,,1  
'EQD',95298,'EQD',69617,'.NET',74709,,1  
'EQD',95681,'EQD',69617,'.NET',74709,,1  
  
![](https://doc-data.castsoftware.com/TG/attachments/566527123/566527122.png)

Query result interpretation

There are 2 analysis units found that are created more than once.

Notes/comments

Ticket # 33484