SCCM SQL Query to fetch AD security Group, which is Associated with all applications deployment collections.
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
I think you need to spend little time integrating AD groups related DATA into this query