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

Answers ( 2 )

    1
    2020-08-27T09:13:21+05:30

    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

Leave an answer

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