try this. IT has the correct joins and such you need. It also included the folders they are in so you can find them.
--Find All Apps that are not deployed, not dependent and not superceded --Also find all dependent apps Select Distinct ParentApp.DisplayName, ParentApp_F.Name AS [ParentAppFolder] /*, ParentApp_DT.Technology AS [ParentAppDeploymentType], ParentApp.IsSuperseded AS [ParentAppIsSuperceded], ParentApp.IsDeployed AS [ParentAppIsDeployed], R.RelationType, ChildApp.DisplayName AS [ChildAppDisplayName], ChildApp_F.Name AS [ChildAppFolder], ChildApp_DT.Technology AS [ChildAppDeploymentType], ChildApp.IsSuperseded AS [ChildAppIsSuperceded], ChildApp.IsDeployed AS [ChildAppIsDeployed] */ >From CM_CEN.dbo.fn_ListApplicationCIs(1033) ParentApp Left Join CM_CEN.dbo.vFolderMembers ParentApp_FM on ParentApp_FM.InstanceKey = ParentApp.ModelName Left Join CM_CEN.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 CM_CEN.dbo.vFolderMembers ChildApp_FM on ChildApp_FM.InstanceKey = ChildApp.ModelName Left Join CM_CEN.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 R.RelationType IN(15,19) AND ParentApp.IsLatest = 1 AND ParentApp_DT.IsLatest = 1 ANd ChildApp.IsLatest = 1 AND ChildApp_DT.IsLatest = 1 --ANd ParentApp.IsDeployed = 1 --AND ParentApp.IsSuperseded = 0 --AND ParentApp.IsDeployed = 1 On Wed, Jun 25, 2014 at 11:56 AM, April Cook <[email protected]> wrote: > Is there a canned report or automated method document or report > applications that have dependencies? If yes, can you relply with the report > name? If not ...geez why not... can you tell me how you are managing the > life cycle of dependencies? > >
