Many thanks Todd. I had searched through my emails, but I did not catch this.. Such a shame that there is not a "canned" report. I have bee reviewing the threads about supersedence... did you end up giving a demo on it? It sure would be great if you could turn that thread inot a nice article on the site, or did I miss that too ;)
On Wed, Jun 25, 2014 at 3:06 PM, Todd Hemsell <[email protected]> wrote: > 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? >>> >>> >> > >
