How can I import computers into SCCM 2012 using a file ?

if you want to import multiple
computers in SCCM 2012 using a file then it’s easy to do so, just make
sure that your file is in CSV format and looks like so

Attached Image: monthly_11_2011/post-1-0-16678900-1321004918.png

In the sample screenshot above I have three machines listed with the
Computername first (name), followed by the SMSBIOS Guid and finally the
MAC Address. You can get the SMSBIOS Guid and MAC Address simply
booting your chosen computer and monitoring the PXE boot process look
for the details below (press PAUSE on your keyboard to make note of the
values or simply pause the VM by pressing the appropriate button as in
the HyperV sample below). You could also ask your Hardware Manufacturer
to provide you this information in CSV format.

Attached Image: monthly_11_2011/post-1-0-95738500-1321005127.png

Now that you have the values add them to your MAC Addresses.CSV file (a text file in notepad or Microsoft Excel) open the ConfigMgr Console and click on Assets and Compliance, click on Devices, in the ribbon above select Import Computer Information

Attached Image: monthly_11_2011/post-1-0-25010800-1321005295.png

select the first option, Import computers using a file

Attached Image: monthly_11_2011/post-1-0-47523100-1321005361.png

point to your CSV file by clicking on browse, open

Attached Image: monthly_11_2011/post-1-0-85059000-1321005427.png

if your CSV file has headings at the top of the file then place a check mark in This file has column headings and then click next

Attached Image: monthly_11_2011/post-1-0-40601800-1321005513.png

look at the data preview, if anything looks incorrect you can go back or cancel, click next if it’s all ok

Attached Image: monthly_11_2011/post-1-0-31820800-1321005598.png

next you can select the target collection, I want to add mine to the Build and Capture Windows 7 X64 collection so I click on Browse and select that collection, choose the one you wish

Attached Image: monthly_11_2011/post-1-0-12238300-1321005703.png

click next through to completion

Attached Image: monthly_11_2011/post-1-0-62492200-1321006195.png

you can then wait for normal discovery to pick up the new objects or force an update by choosing update membership on the chosen collection, answer yes whem prompted

Attached Image: monthly_11_2011/post-1-0-43459600-1321006844.png

refresh the collection and the computers appear (if you’ve just imported them, give it a couple of minutes before they appear)

Attached Image: monthly_11_2011/post-1-0-44315500-1321006971.png

original post >

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.