In this article, I will show you how to export SCCM device collection using multiple methods. You can manually export all the devices from a SCCM device collection to a CSV file, use a PowerShell command or use the export option from SCCM console and export them to an Excel file.
When you have a device collection that has got numerous devices or users, you may want to export them to an Excel file and analyze the list. Exporting a device collection or a user collection can be done from SCCM console.
In some cases, you may be asked to export devices from SCCM device collection to a CSV file and compare it with another report. In such situations, you can use the export option in SCCM console to complete your task.
In SCCM, collections are groupings of users or devices. Use collections for tasks like managing applications, deploying compliance settings, or installing software updates.
Ways to Export Device Collection in SCCM
There are multiple ways to export SCCM device collection and here are some of them:
- Using SCCM console to export device collection details – This is the easiest and preferred option.
- Use a PowerShell script to export the device collection – Complex depending upon the script. The PowerShell script to export device collections is available on many sites on the web.
- Export-CMCollection PowerShell cmdlet – This option is for SCCM admins who prefer to manage ConfigMgr environment using PowerShell cmdlets.
- Use SCCM Report to export resources from a device collection – This is a good option if you have access to SCCM reports. Reports allow you to export a device collection to multiple file formats.
There is a difference between exporting selected devices from a device collection and exporting all devices from a device collection in SCCM. I will clarify more details about it in next section.
If you are using a PowerShell script to export the devices out of device collection, it may or may not work correctly. Since we have a nicer built-in option to export the devices, use it to export device collection.
Manually Export Device Collection to Excel
Is there a way to export a device collection to a CSV or Excel file? Yes, the easiest way to export devices from a collection is to open your collection, select the devices, do a Ctrl+C and then open excel and past the clipboard contents.
Even before Microsoft added the Export option in SCCM console, the option to copy the devices and export to excel feature was already present in SCCM. You can also export selected devices from SCCM console to an Excel file.
Let’s see how to export device collection manually to Excel file. Launch the SCCM console and go to Assets and Compliance > Devices. Open a device collection in SCCM and select all devices using the Ctrl+A keys.
To copy the devices and other information, use Ctrl+C keys.
Open the Excel application and select Blank Workbook. Now paste the devices in Excel. This is how you manually export SCCM device collection to Excel.
Export SCCM Device Collection from ConfigMgr Console
From the SCCM console, you can export a device collection using the following steps:
- Launch the Configuration Manager console.
- Go to Assets and Compliance\Overview\Device Collections.
- Right-click a device collection that you want to export and select Show Members.
The Show members option displays all the devices that are part of the device collection. Right-click anywhere on the screen and select Export to CSV file > Export all items.
The data along with column names is copied over to CSV file. You can add or remove columns and then copy the device collection details to Excel file.
Note: When you select Export to CSV file, there is another option called Export Selected items. This option exports the selected devices from the collection. You have to select the devices first and then use this option.
When you select Export all items, you will be prompted to save this data to an Excel file (CSV file). Specify the file name and save it to a known location on your hard drive.
Now you can open the file with Excel app on your computer and view all the devices and associated details that were exported from the SCCM device collection.
Interesting Read: Find SCCM Package Size from DP Console and SQL Query
Export Device Collection using Export-CMCollection PowerShell cmdlet
You can use the Export-CMCollection PowerShell command to export the SCCM device collection:
- Launch the ConfigMgr console.
- In the upper-left corner, there’s a blue rectangle. Select the white arrow in the blue rectangle, and choose Connect via Windows PowerShell.
- To export the SCCM device collection run the PowerShell command:
Export-CMCollection -Name "Windows 11 Devices" -ExportFilePath "C:\w11.mof"
In the above example, the Windows 11 Devices is the name of the device collection. You must provide an export file path and specify where you want to save the .mof file.
This exported .mof file can be used to import the device collection back into SCCM console.
Use SCCM Reports to Export Devices from a Device Collection
If you have access to SCCM reports, you can run a report to find the resources in a specific collection. This SCCM report applies to both user collections and device collections.
Interesting Read: How to add Collection parameter in SCCM report
In the SCCM console, go to Monitoring\Overview\Reporting\Reports. From the list of all reports, look for the report named “All resources in a specific collection“. Right-click this report and select Run.
On the report window, click Values option and select a device collection for export and click View Report. Now you can view all the devices that belong to the device collection. Use the export options in the report to export the device collection to various file formats.
You now know the different methods to export devices from a SCCM device collection. Let me know which method do you normally prefer to export a device collection in your daily job as SCCM admin. If you have any suggestions or feedback, let me know in the comments section.