Solved

Use a vbscript to change a registry key based on information in an array

Posted on 2008-06-13
5
1,349 Views
Last Modified: 2012-06-21
My company uses a config.xml file to determine where packages will be installed from. The location of the config file that each system should use is set through a registry key. Recently, we discovered that a lot of the systems did not have the correct registry key and need to be corrected.

Here is an example of my problem.
A system will look in HKLM\Software\Custom\Config and see \\USAT001\Custom\ccpconfig.xml as the location for the config file. However, this is incorrect and should be  \\USME032\Custom\ccpconfig.xml. Each system at my company uses the first four letter as the location in the computer name. So any system starting with USME should use  the \\USME032\Custom\ccpconfig.xml.

How can I script it so a the computer name is examined? Once the computer name is determined, it changes the registry key to the correct location based on the first four letter.

Any help would be appreciate greatly.
0
Comment
Question by:Lorrec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Shift-3
ID: 21781520
Paste the script below into a text file with a .vbs extension.  Running it will modify the string value Config under the key HKLM\Software\Custom.


Const HKEY_LOCAL_MACHINE = &H80000002
 
Set WSHShell = CreateObject("WScript.Shell")
strComputer = WshShell.ExpandEnvironmentStrings("%computername%")
strPrefix = Left(strComputer, 4)
 
Set objRegistry = GetObject _
    ("winmgmts:\\" & strComputer & "\root\default:StdRegProv")
 
strKeyPath = "Software\Custom"
strValueName = "Config"
strData = "\\" & strPrefix & "032\Custom\ccpconfig.xml"
 
errReturn = objRegistry.SetStringValue _
    (HKEY_LOCAL_MACHINE, strKeyPath, strValueName, strData)

Open in new window

0
 

Author Comment

by:Lorrec
ID: 21781831
Thank you for the quick response. This gets me started.

I have one more question if you do not mind.
Not all of the registry keys should be set to USME032\Custom\ccpconfig.xml. Would it be possible to have the different changes in the script so it can loop through them them and choose which is correct based on computer name.

For example,

First 4 of Computer Name                             Location of Config file
SCAB                                                      \\SCAB001\custom\config.xml
USMD                                                       \\USMD005\custom\config.xml

Would it be possible to have it look at the computer name and then decide based on the first 4 of that computer name what to change the registry to?
0
 
LVL 38

Accepted Solution

by:
Shift-3 earned 500 total points
ID: 21782322
Ok, I think I see what you're saying.  

The revised code below allows you to specify a location for each 4-letter prefix.  Add further locations by following the format of lines 5 and 6.


Const HKEY_LOCAL_MACHINE = &H80000002
 
set objLocations = CreateObject("Scripting.Dictionary")
objLocations.CompareMode = VBTextCompare
objLocations.Add "SCAB", "\\SCAB001\custom\config.xml"
objLocations.Add "USMD", "\\USMD005\custom\config.xml"
 
Set WSHShell = CreateObject("WScript.Shell")
strComputer = WshShell.ExpandEnvironmentStrings("%computername%")
strPrefix = Left(strComputer, 4)
strLocation = objLocations.Item(strPrefix)
 
Set objRegistry = GetObject _
    ("winmgmts:\\" & strComputer & "\root\default:StdRegProv")
 
strKeyPath = "Software\Custom"
strValueName = "Config"
strData = strLocation
 
errReturn = objRegistry.SetStringValue _
    (HKEY_LOCAL_MACHINE, strKeyPath, strValueName, strData)

Open in new window

0
 

Author Comment

by:Lorrec
ID: 21782369
I really appreciate this. You pointed me in the right direction. Thank you for the help.
0
 

Author Closing Comment

by:Lorrec
ID: 31467007
Thanks again for all the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Well hello again!  Glad to see you've made it this far without giving up.  In this, the fourth installment of my popular series, I'm going to cover functions and subroutines, what they are, and why they are useful.  Just in case you stumbled onto th…
This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

696 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