anyweb Posted October 21, 2008 Report post Posted October 21, 2008 In the Operating System Deployment section of SCCM right click on Computer Association and choose Import Computer Information when the wizard appears select Import Computers using a file The file itself must contain the information we need in this (CSV) format COMPUTERNAME,GUID,MACADDRESS (sample below) deployvista,3ED92460-0448-6C45-8FB8-A60002A5B52F,00:03:FF:71:7D:76NEWCOMP1,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) 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 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 Next choose the target collection where you want these computers to end up in review the summary in SCCM collections, we can now see the computers we've just imported from File, thats it ! If you want to script this then read this post on MSDN cheers anyweb Quote Share this post Link to post Share on other sites More sharing options...
madmattwall Posted November 30, 2009 Report post Posted November 30, 2009 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 Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted November 30, 2009 Report post Posted November 30, 2009 no it can't you must enter the computername and MAC address or computername and GUID cheers niall Quote Share this post Link to post Share on other sites More sharing options...
madmattwall Posted November 30, 2009 Report post Posted November 30, 2009 ok thanks for the reply. no it can't you must enter the computername and MAC address or computername and GUID cheers niall Quote Share this post Link to post Share on other sites More sharing options...
KLaauser Posted May 27, 2011 Report post Posted May 27, 2011 What is the easiest way to get the MAC &/|| GUID of a group of machines? or is there no easy way and it all has to be done manually? EDIT: By 'manually', I mean going around to every computer and writing it down/copy pasting Quote Share this post Link to post Share on other sites More sharing options...
smmccarthy Posted July 15, 2011 Report post Posted July 15, 2011 What is the easiest way to get the MAC &/|| GUID of a group of machines? or is there no easy way and it all has to be done manually? EDIT: By 'manually', I mean going around to every computer and writing it down/copy pasting Intel provide a script as part of their vPro offering that can be used to automatically import the details into an SCCM collection from a target PC. This is available here: SCCMauto I have modded the script to allow the details to be appended to a csv file as I was having firewall issues when automatically importing the details into SCCM. Just insert the code into a .vbs file and run from a command prompt using the cscript command 'Create an object to connect to the local WMI provider Set objService = GetObject("winmgmts:\root\cimv2") 'Update the status on the screen wscript.echo "Looking up host name, FQDN, MAC & UUID..." 'Get the MAC, hostname & DNS information Set objNetwork = objService.ExecQuery ("Select * from Win32_NetworkAdapterConfiguration where IPEnabled = True") for each objItem in objNetwork strMAC = objItem.MACAddress 'If the computer name was not passed as a command line argument, read it from the local WMI interface if strHostName="" then strHostName = Ucase(objItem.DNSHostName) end if if strDNSSuffix="" then strDNSSuffix = Ucase(objItem.DNSDomain) end if strDNSDomain = objItem.DNSDomain next 'Combine the computer name and DNS suffix to create the computer's FQDN strFQDN = Ucase(strHostName & "." & strDNSSuffix) 'Get the UUID Set objSysComps = objService.ExecQuery("Select * from Win32_ComputerSystemProduct") set objSysUUID = objService.ExecQuery ("Select * from Win32_NetworkAdapterConfiguration where IPEnabled = True") for each objItem in objSysComps strUUID = objItem.UUID next 'Echo the values that will be added to the SCCM server wscript.echo wscript.echo "Host Name: " & strHostname wscript.echo "FQDN: " & strFQDN wscript.echo "MAC: " & strMAC wscript.echo "UUID: " & strUUID wscript.echo Dim Filename Dim OutputFile Filename = "PC-Details.csv" 'File to output results to Set objFSO = CreateObject("Scripting.FileSystemObject") If not objFSO.FileExists(Filename) then Set objFile = objFSO.CreateTextFile(Filename) Wscript.sleep(2000) 'Pause while file is being created End If 'If objFSO.FileExists(Filepath & Filename) then 'Set objFile = objFSO.GetFile(Filepath & Filename) 'Lastmodifieddate = objFile.DateLastModified Const ForAppending = 8 Set outputFile = objFSO.OpenTextFile(Filename, ForAppending, true) ' Open file for writing OutputFile.WriteLine strHostname & "," & strUUID & "," & strMAC'Write filename and last modified date to output file OutputFile.Close 'End If set objFSO = Nothing Quote Share this post Link to post Share on other sites More sharing options...
Hamilton Posted October 10, 2011 Report post Posted October 10, 2011 Awesome information, Is it possible to make an association with an existing PC for Side by Side Migration? Quote Share this post Link to post Share on other sites More sharing options...
jm9598 Posted March 9, 2012 Report post Posted March 9, 2012 Can this be done via vbscript or hta? I have certain folks that need to image bare metal systems, but I don't want them on my SCCM server or in the SCCM console. Quote Share this post Link to post Share on other sites More sharing options...
gona Posted March 28, 2012 Report post Posted March 28, 2012 Is it possible to create collection and import cvs file. i wont to deploy security updates with Software Updates and i can not find how to import csv file Quote Share this post Link to post Share on other sites More sharing options...
AlephNull Posted April 26, 2012 Report post Posted April 26, 2012 Hi, thanks for all the excellent info. I was just on ph with MS ( yes of all people!) okay they are telling me ' oh no you mean 'Unknown Computers & etc....' and I am like NO I do not mean Unknown Computers....I don't use Unknown Computers....duuuuh! am I missing something here? I use a csv import and do an SCCM Flash /CD boot...they are not Unknown!...Not only these guys but the SCCM guy on site....I had some problems with this Unknown Computer thing....anyway....and I would rather continue using the import csv....tnks....I had to verify someone else has done this..... AlephNull.. Quote Share this post Link to post Share on other sites More sharing options...
pranay bhagat Posted June 28, 2012 Report post Posted June 28, 2012 hi all, we are working on replace scenario currently & have imported few xp & win 7 machines in different collections using CSV files. the only part we are stuck is on the association of these machine ,we don't want to do it manually we want to have an automated process which does this work so that after the machine association we can run the Replace TS. Can we do this in SCCM 2007 or do we need scripts for this process. Thanks Pranay. Quote Share this post Link to post Share on other sites More sharing options...