no, no demo yet. Director wants to give MS a chance to resolve it before I get others involved. I can answer questions and what not though. I Think I sent enough so that anyone else that runs into this issue can find it.
On Wed, Jun 25, 2014 at 2:42 PM, April Cook <[email protected]> wrote: > 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? >>>> >>>> >>> >> >> > >
