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
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
SQL query to find application ad group name and collection name in sccm
Answers ( 2 )
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];
Application group names ? Why do you need this ?
I don’t have any ready made query
But you can check
https://www.anoopcnair.com/sccm-report-include-membership-collection-rule-configmgr-query/
https://www.anoopcnair.com/configmgr-application-deployment-status-sql-query-custom-report/