[anyweb]

In the Operating System Deployment section of SCCM right click on Computer Association and choose Import Computer Information

 import_computer_information.jpg (24.17K)
Number of downloads: 34

when the wizard appears select Import Computers using a file

 from_a_file.jpg (35.12K)
Number of downloads: 18

The file itself must contain the information we need in this (CSV) format

COMPUTERNAME,GUID,MACADDRESS

(sample below)

Quote

deployvista,3ED92460-0448-6C45-8FB8-A60002A5B52F,00:03:FF:71:7D:76
NEWCOMP1,55555555-5555-5555-5555-555555555555,05:06:07:08:09:0A
NEWPXE,23CA788C-AF62-6246-9923-816CFB6DD39F,00:03:FF:72:7D:76
w2k8deploy,BFAD6FF2-A04E-6E41-9060-C6FB9EDD4C54,00:03:FF:77:7D:76

if we look at the last line, I've marked the computer name in Red, the GUID in BLUE and the MAC address in GREEN, separate these values with commas as above.

w2k8deploy,BFAD6FF2-A04E-6E41-9060-C6FB9EDD4C54,00:03:FF:77:7D:76

the file can be a standard TEXT file that you create in notepad, and you can rename it to CSV for easier importing into our wizard...

so, click on Browse and browse to where you've got your CSV file

on the Choose Mapping screen, you can select columns and define what to do with that mapping, eg: you could tell it to ignore the GUID value (we won't however)

 ignore_guid.jpg (107.36K)
Number of downloads: 23

on the next screen you'll see a Data Preview, and this is useful as it will highlight any errors it finds with a red exclamation mark, in the example below a typo meant that it correctly flagged the MAC address as invalid

 error.jpg (44.64K)
Number of downloads: 17

so edit your CSV file again and fix the error, click previous (back) and try again until it looks like this

here's a sample file..  macguidcomputername.csv (261bytes)
Number of downloads: 102

 allok.jpg (41.58K)
Number of downloads: 11

Next choose the target collection where you want these computers to end up in

 select_collection.jpg (34.86K)
Number of downloads: 11

review the summary

 summary.jpg (50.56K)
Number of downloads: 9

in SCCM collections, we can now see the computers we've just imported from File,

 computers_added.jpg (55.75K)
Number of downloads: 14

thats it !

cheers
anyweb

[madmattwall]

hi there,

can this be done with the computer name only, i.e drop the mac and guid ???

only my machines are already in SCCM and displaying but i need to define this to a collection based off the CSV file with computer name only in it ??

hope you can shed some light ?

cheers

Matt

[anyweb]

no it can't you must enter the computername and MAC address or computername and GUID

cheers
niall

[madmattwall]

ok thanks for the reply.

anyweb, on 30 November 2009 - 03:01 PM, said:

no it can't you must enter the computername and MAC address or computername and GUID

cheers
niall