oops, you want to remove this. R.RelationType IN(15,19) There is a view that has those relation types. forgot the name of it.
On Wed, Jun 25, 2014 at 2:05 PM, Todd Hemsell <[email protected]> wrote: > 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? >> >> >
