I have created some SSRS Reports based on this data to view the dependencies. http://eskonr.com/2014/06/sccm-configmgr-2012-ssrs-report-list-applications-and-its-dependencies/
Thanks,Eswar Koneti www.eskonr.com Date: Wed, 25 Jun 2014 14:06:56 -0500 Subject: Re: [mssms] Report of applications with dependencies From: [email protected] To: [email protected] 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?
