Hi I need to create 300 boundaries in sccm 2007. each one with its own ip adress range and name. does someone have a script that reads an excel/csv file and creates boundaries from the data within? appreciate the help. tamir

I have successfully used the script from below location. http://alipka.wordpress.com/2009/01/05/script-to-create-sccm-site-boundaries-automatically Need to edit the SetupSiteBoundaries.vbs and enter in your own gsServer, gsUser, gsPass connection information Put all your IP range information into the siteboundaries.txt text file with a format like below, changing CEN to your Site Code, Boundary Name to the name you want, and naturally the IP details. 10.0.0.1-10.0.0.255,IP Ranges,Boundary Name,0,CEN I suggest that you test this with just one IP Range first so you know you have the correct connection info and format in the text file. Cheers, Shane (Please "Propose as answer" / "Mark as answer" / "Vote as helpful" if appropriate)

you can use this tool :- ConfigMgr Site Bound Tool from the location http://www.myitforum.com/myITWiki/SCCMTools.ashx

Hi this tool works only on 32 bit env. so I cant use it. thanks anyway. Tamir

Hi I did find this script and it works. however, I need to it to reads an excel/csv file where all the information on the 300 site reside. I just dont know vb that well to do the change. if you can help with this, please reply. Thanks Tamir

we have used this tool in our X64 bit environment and it works. Have you tried this one ?

We did not use the "ConfigMgr Site Bound Tool" also due to not being able to do the job on a X64 system. tamimh... re your need for the script to read and Excel/csv file... surely you can convert your CSV file (which is comma separated) ... into the format that the script requires... which is just rows of data with values separated by commas :-) So... get your CSV file into the right columns... save as CSV... open in Notepad... and make sure it is in the right format / columns. Cheers, Shane