PENDING Export All Devices with their Collections in SCCM

[buma]

I haven't come up with a way for this yet. I know I can export all the devices and the collections separately. Is there a way in SCCM to export all the devices we have with all the collections they are in?

 

[Prajwal Desai]

That is not something I believe is possible. However, I leave this question open for others to respond to.

 

[Garth]

I haven't come up with a way for this yet. I know I can export all the devices and the collections separately. Is there a way in SCCM to export all the devices we have with all the collections they are in?

Sure you can easily do this with a SQL query and therefore with PowerShell too.

SQL Server views - Configuration Manager

A Microsoft SQL Server view is a virtual table whose contents are based on the result from a SQL query.

learn.microsoft.com

How to use PowerShell to query SQL Database?

This article will show you how to access MECM database using PowerShell to query SQL, to avoid the WMI limitations.

askgarth.com