How to check whether an application has Dependencies and References

Hi @Boopathi Subramaniam ,

We could use the following SQL query to check if the application has Dependencies:

SELECT DISTINCT  
ParentApp.DisplayName ParentAppName,  
ParentAppF.Name ParentAppFolder,  
ParentApp.CreatedBy ParentAppCreatedBy,  
ParentAppDT.DisplayName ParentAppDTName,  
ChildApp.DisplayName ChildAppDisplayName,  
ChildAppF.Name ChildAppFolder,  
ChildAppDT.DisplayName ChildAppDTName  
FROM   
fn_ListApplicationCIs(1033) ParentApp  
LEFT JOIN vFolderMembers ParentAppFM on ParentAppFM.InstanceKey = ParentApp.ModelName  
LEFT JOIN vSMS_Folders ParentAppF on parentAppF.ContainerNodeID = ParentAppFM.ContainerNodeID  
LEFT JOIN fn_ListDeploymentTypeCIs(1033) ParentAppDT on ParentAppDT.AppModelName = ParentApp.ModelName  
LEFT JOIN vSMS_AppRelation_Flat R on R.FromApplicationCIID = ParentApp.CI_ID  
LEFT JOIN fn_ListApplicationCIs(1033) ChildApp on ChildApp.CI_ID = R.ToApplicationCIID And ChildApp.IsLatest = 1  
LEFT JOIN vFolderMembers ChildAppFM on ChildAppFM.InstanceKey = ChildApp.ModelName  
LEFT JOIN vSMS_Folders ChildAppF on ChildAppF.ContainerNodeID = ChildAppFM.ContainerNodeID  
LEFT JOIN fn_ListDeploymentTypeCIs(1033) ChildAppDT on ChildAppDT.AppModelName = ChildApp.ModelName  
WHERE  
ParentApp.IsLatest = 1  
AND ParentAppDT.IsLatest = 1  
AND ChildApp.IsLatest = 1  
AND ChildAppDT.IsLatest = 1  
ORDER BY 1  

I test it in my environment, it could be shown childAPPDTName which the application has Dependencies:

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.