ConfigMgr Import Tool v1.0
- Bulk import from CSV
- Removes objects discovered by System Discovery before importing the device, to fix issues with duplicate objects
- Verifies if the machine name and/or MAC address already exists
- Possibility to change MAC addresses
- Logging provided in a CMTrace format
- Automatically populates MAC address from the ConfigMgr database
- Provides the user a dropdown list of collections within a specific folder in ConfigMgr
- Various validation checks
- ConfigMgr 2012 R2 SP1 or later
- Powershell v3
- Permissions required by account running the tool:
- Import new devices
- Delete devices
- Add device to collection
- Example of role with minimum permissions:
The ConfigMgr Import Tool v1.0 is available on the TechNet Gallery.
Running the Tool
- Open a new Powershell window with a user that has sufficient permissions in ConfigMgr.
- Browse to the folder containing the tool and run it with the command line:.\ConfigMgr-Import-Tool-v1.0.ps1 -<Parameters>
.\ConfigMgr-Import-Tool-v1.0.ps1 -Container OSD -SiteCode P01 -SiteServer p01.danielclasson.local -LogPath \\p01\logs$
- Container = Folder in ConfigMgr containing OSD collections.
- SiteCode = ConfigMgr Site Code
- SiteServer = FQDN of ConfigMgr Site Server
- LogPath = UNC path to log files. REQUIRED if logs are to be written.
- CSVPath = UNC path to initial CSV path directory. OPTIONAL.
Manually import devices
If you wish to import a single computer or a few computers, use Manually import devices.
However, if you wish to import many computers, refer to the next section on how to Bulk Import Devices.
- Simply enter the Device Name in the text box on the right hand side.
- If the device exists, press Validate to populate the MAC address field.
- If the device does not exist, enter the MAC address in the MAC address field.
- If the device exists, but you want to change the MAC address in the database, change the MAC address in the field.
Add to import list
- If the validation is successful, Add to selection will be enabled. Press the button to add the device to the list.
- Continue with these steps until you have the desired devices in the list.
- If you want to remove a computer from being imported, select, the computer in the list and press the button Remove from selection.
When the correct devices are in the import list, press Import Devices.
Bulk Import Devices
The best way to import many computers at a time is by bulk importing them using a CSV file.
Create a file name with a *.csv extension with two rows named ComputerName and MAC like the below example:
Import devices from CSV
- Once the CSV file is ready, select Bulk Import Devices.
- Select the OS Deployment Collection from the dropdown list.
- Press Browse and select the CSV file.
- Verify that the correct devices are in the import list. If not, modify the CSV and import it again.
- When ready, press Import Devices.
I hope that the tool will prove useful to you and please send me suggestions for further improvements 🙂
About the author
Daniel Classon works as a Senior Consultant at Mansoft, focusing on Microsoft Configuration Manager, Windows 10 and Powershell
- How to install .NET Framework 3.5 on Windows Server 2012 and Windows Server 2012 R2 958,810 views
- Issue with mounting new ISO files from TechNet in Windows 8 and Windows 8.1 Preview 63,517 views
- Solution to OSD issue 80072ee7 30,345 views
- Powershell: Script to set Outlook 2010/2013 signature using information populated from Active Directory 31,425 views
- Guide: How to get PXE boot to work in Hyper-V 104,601 views
- Guide: How to force specific sites to always run in Compatibility View using Group Policy 139,889 views
- How to change between a Full Installation (GUI) and Server Core in Windows Server 2012 63,613 views
- Guide: Solving WDS issue with DHCP port conflict 11,553 views
- Hyper-V: Issue when starting virtual machine from downloaded ISO file 7,280 views
- How to check status of Bitlocker encryption on a client 116,391 views