Need report or method to export AD group data.

Question

Hello expert,

I need a report that provides me data on which apps are mapped to AD groups in SCCM, and I also need a report from Intune showing which apps are deployed to which groups. Please help.

Answer 1

Hi,

Thank you for posting in Microsoft Q&A forum.

==>I need a report that provides me data on which apps are mapped to AD groups in SCCM

Do you mean you have created a collection based on AD group and want to query which apps are deployed to the AD group-based collection? If yes, we can try below report or query:

Lists the Application Deployments for a Device or User Collection.

SCCM Report Applications packages assigned to specific collection with user experience settings

SCCM sql query deployment status of application

==>I also need a report from Intune showing which apps are deployed to which groups.

Based on my researching, currently, there is no built-in method to query the software assigned to a specific group in the portal.

You can try to do it with PowerShell, please refer to:

Get All Windows Apps Assigned to a Group

Thanks for your time. Have a nice day!

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.