SQL query to find application ad group name and collection name in sccm

Question

SQL query to find application ad group name and collection name in sccm

solved 0
Saurabh Sharma 2020-08-26T17:54:06+05:30 2 Answers 640 views Beginner
0

Answers ( 2 )

  2. Ankit Shukla
    1
    2020-08-27T09:13:21+05:30
    Reply

    Use below query to find application and its collection, for AD security group you can use include member query.

    SELECT DISTINCT app.DisplayName AS ‘Application Name’, aa.CollectionName AS ‘Deployed to Collection’, aa.CollectionID,v_ContentInfo.ContentSource
    FROM dbo.fn_ListDeploymentTypeCIs(1033) AS dt
    inner join dbo.fn_ListLatestApplicationCIs(1033) AS app ON dt.AppModelName = app.ModelName
    left outer join v_AppDeploymentSummary ads on app.CI_ID = ads.CI_ID
    left outer join v_ApplicationAssignment aa on ads.AssignmentID = aa.AssignmentID
    left outer join v_ContentInfo on DT.CONTENTID = V_CONTENTINFO.CONTENT_UNIQUEID
    where aa.CollectionName not like ‘%NULL%’
    Order by [Application Name];

    Best answer
  4. Anoop C Nair
    0
    2020-08-27T02:15:41+05:30
    Reply

Leave an answer

Sorry, you do not have permission to answer to this question .