If oracle Client is marked as dependency application for the
most of the application in the environment, then this below query will come in
handy.
Just update application name in the highlighted place in the
below query.
select parentapp.displayname
[Application Name],
parentapp.CreatedBy
[Created By],
ParentApp_F.Name AS [ParentAppFolder] ,
ParentApp_DT.Technology AS [ParentAppDeploymentType],
case when parentapp.IsEnabled='1' then 'Yes' else 'No' end as IsEnabled,
case when parentapp.IsDeployed='1' then 'Yes' else 'No' end as IsDeployed,
parentapp.NumberOfDeploymentTypes
[No of DT],
parentapp.NumberOfDeployments
[No of Deployments],
parentapp.NumberOfDevicesWithApp,
parentapp.NumberOfDevicesWithFailure
From dbo.fn_ListApplicationCIs(1033) ParentApp
Left Join dbo.vFolderMembers ParentApp_FM on
ParentApp_FM.InstanceKey = ParentApp.ModelName
Left Join dbo.vSMS_Folders ParentApp_F on
ParentApp_F.ContainerNodeID = ParentApp_FM.ContainerNodeID
Left Join
fn_ListDeploymentTypeCIs(1033) ParentApp_DT ON
ParentApp_DT.AppModelName = ParentApp.ModelName
Left Join
vSMS_AppRelation_Flat R on R.FromApplicationCIID =
ParentApp.CI_ID
Left Join
fn_ListApplicationCIs_List(1033) ChildApp on
ChildApp.CI_ID =
R.ToApplicationCIID And
ChildApp.IsLatest =
1
Left Join dbo.vFolderMembers ChildApp_FM on
ChildApp_FM.InstanceKey =ChildApp.ModelName
Left Join dbo.vSMS_Folders ChildApp_F on
ChildApp_F.ContainerNodeID = ChildApp_FM.ContainerNodeID
Left Join
fn_ListDeploymentTypeCIs(1033) ChildApp_DT ON
ChildApp_DT.AppModelName = ChildApp.ModelName
where ChildApp.DisplayName='Application_Name_in_Arp' and
parentapp.IsLatest='1'
group by parentapp.DisplayName,parentapp.CreatedBy,parentapp.NumberOfDeploymentTypes,parentapp.NumberOfDeployments,
parentapp.NumberOfDevicesWithApp,
parentapp.NumberOfDevicesWithFailure,
parentapp.IsEnabled,
parentapp.IsDeployed,
ParentApp_F.Name,
ParentApp_DT.Technology,
ParentApp.IsSuperseded
