?
Solved

Editing Network Adapters using VBScript

Posted on 2008-10-28
9
Medium Priority
?
627 Views
Last Modified: 2013-11-10
I am fairly new to vbs.  I am trying to write a script for my servers, so that I can edit thier network adapter easier on builds and rebuilds.  I have pieced together the following script from snippets on the web, and edited it so that I would prompt for input instead of statically assigning the variables, however it now gives me a type mismatch on line 26...Any ideas?  Also I would like to modify it so that it edits and prompts for the primary and secondary dns.

________________________________________
strConnection = "Local Area Connection"
 
strComputer = InputBox( "What is the name of the Server?" ) 
 
 
strIP = InputBox( "What is the new IP?:" )
 
 
strMask = InputBox( "What is the Subnet Mask for this IP?" )
 
strGatewayIP = InputBox( "What is the default gateway?" )
 
MsgBox("You entered Server" & " " & strComputer & " "  & "and the IP" & " " & strIP)
 
 
set objWMI = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
set colNA = objWMI.ExecQuery("select * " & _
                            " from Win32_NetworkAdapter " & _
                            " where NetConnectionID = '" & strConnection & "'" ) 
for each objNA in colNA
   set colNAConfig = objWMI.ExecQuery _
      ("ASSOCIATORS OF {Win32_NetworkAdapter.DeviceID='" & _
        objNA.DeviceID & "'} " & _
      " WHERE resultClass = win32_NetworkAdapterConfiguration ")
   for each objNAConfig in colNAConfig
      intRC = objNAConfig.EnableStatic(strIP,strMask)
      intRC2 = objNAConfig.SetGateways(strGatewayIP)
      if intRC = 0 and intRC2 = 0 then
         WScript.Echo "IP address configured for " & strConnection
      elseif intRC = 1 or intRC2 = 1 then
         WScript.Echo "You must reboot for the changes to take effect for " & _
                      strConnection
      else
         WScript.Echo "There was an error configuring IP for " & _
                      strconnection & ": " & intRC & " and " & intRC2
      end if
   next
next

Open in new window

0
Comment
Question by:corphealth
  • 4
  • 4
9 Comments
 

Author Comment

by:corphealth
ID: 22823332
make that line 18 =)
change.ip.vbs.error.jpg
0
 
LVL 3

Expert Comment

by:Angelized
ID: 22829062
This script is just working fine for me. At least no errors a line 18
What version of server are you running ?
0
 

Author Comment

by:corphealth
ID: 22832740
i changed the script now im getting the error in the screen shot below... Are you saying you used this script and it actually changed the network details for the selected box?

change.ip.vbs.error2.jpg
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:corphealth
ID: 22832754
Im running it from an XP machine
0
 
LVL 1

Expert Comment

by:jimmyb0004
ID: 22833843
Usually a type mismatch is because your are trying to input or test a using a string or another type against an int or something to that effect. Are you sure you don't have to parse out the ip address or something so that it is an int and not a string? I will look more closely when I get a chance, but try looking over your code to make sure that everything should be a string against string check/enter. If that's not it, maybe look at your strings and check into the escape characters for your "path\path\". sometimes you have to add an extra escape character so that it reads the path line properly, and that can cause issues as well. I will look at your code closer when I get off work and can check it out.
0
 
LVL 1

Expert Comment

by:jimmyb0004
ID: 22833900
Sorry, I also noticed on your line 26. You are trying to make an int variable = to your enable static with string input params. Are you at any point changing the input to int type? Maybe try accepting the ip addy as an int instead and just parse or convert the input coming in from the input box from string to int.
0
 
LVL 1

Expert Comment

by:jimmyb0004
ID: 22833986
One last thing for now. I also noticed that you are inside your foreach statement while doing some of this. I think that inside there, and much as your code says with the objNAconfig..etc, you are dealing with objects and trying to assign and object to an int. I know, at least in some cases, you have to parse or convert the object from an object type to an int if you are trying to assign it to an int variable. Again, i'll check back later. Sorry for all the posts. I'll stop now for awhile. Hope all this helps.
0
 

Accepted Solution

by:
corphealth earned 0 total points
ID: 22834543
changed lines 26 and 27 to the below and it now works.


intRC = objNAConfig.EnableStatic(Array(strIP), Array(strMask))   
      intRC2 = objNAConfig.SetGateways(Array(strGatewayIP))

Open in new window

0
 
LVL 1

Expert Comment

by:jimmyb0004
ID: 22834701
So it was looking for a collection.. that explains it. Nice work. Congrats :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question