SCCM SQL Query to fetch AD security Group, which is Associated with all applications deployment collections.
Question
Hi Team,
We require to fetch AD security Group details, which is Associated with all applications/package deployment collections (user based/Device based). Can someone please help us for this requirements.
Answer ( 1 )
I think the nearest (in line with your requirements) SQL query I can find out is given below
https://www.anoopcnair.com/sccm-application-deployment-custom-report-sql-query-configmgr/
I think you need to spend little time integrating AD groups related DATA into this query