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 )

  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

Leave an answer

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