VBScript

Scriptomatic 2.0

2008-01-24T16:32:00.000-08:00

The Scriptomatic 2.0 is great tool that you can use to assist you in developing WMI Scripts. To download Scriptomatic 2.0, click here to go to Microsoft's Web site. This tool makes it really easy to write WMI queries.

For example, here is a WMI query that will display your processor information in a text file:

On Error Resume Next

Const wbemFlagReturnImmediately = &h10
Const wbemFlagForwardOnly = &h20

arrComputers = Array(".")
For Each strComputer In arrComputers
WScript.Echo
WScript.Echo "=========================================="
WScript.Echo "Computer: " & strComputer
WScript.Echo "=========================================="

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Processor", "WQL", _
wbemFlagReturnImmediately + wbemFlagForwardOnly)

For Each objItem In colItems
WScript.Echo "AddressWidth: " & objItem.AddressWidth
WScript.Echo "Architecture: " & objItem.Architecture
WScript.Echo "Availability: " & objItem.Availability
WScript.Echo "Caption: " & objItem.Caption
WScript.Echo "ConfigManagerErrorCode: " & objItem.ConfigManagerErrorCode
WScript.Echo "ConfigManagerUserConfig: " & objItem.ConfigManagerUserConfig
WScript.Echo "CpuStatus: " & objItem.CpuStatus
WScript.Echo "CreationClassName: " & objItem.CreationClassName
WScript.Echo "CurrentClockSpeed: " & objItem.CurrentClockSpeed
WScript.Echo "CurrentVoltage: " & objItem.CurrentVoltage
WScript.Echo "DataWidth: " & objItem.DataWidth
WScript.Echo "Description: " & objItem.Description
WScript.Echo "DeviceID: " & objItem.DeviceID
WScript.Echo "ErrorCleared: " & objItem.ErrorCleared
WScript.Echo "ErrorDescription: " & objItem.ErrorDescription
WScript.Echo "ExtClock: " & objItem.ExtClock
WScript.Echo "Family: " & objItem.Family
WScript.Echo "InstallDate: " & WMIDateStringToDate(objItem.InstallDate)
WScript.Echo "L2CacheSize: " & objItem.L2CacheSize
WScript.Echo "L2CacheSpeed: " & objItem.L2CacheSpeed
WScript.Echo "LastErrorCode: " & objItem.LastErrorCode
WScript.Echo "Level: " & objItem.Level
WScript.Echo "LoadPercentage: " & objItem.LoadPercentage
WScript.Echo "Manufacturer: " & objItem.Manufacturer
WScript.Echo "MaxClockSpeed: " & objItem.MaxClockSpeed
WScript.Echo "Name: " & objItem.Name
WScript.Echo "OtherFamilyDescription: " & objItem.OtherFamilyDescription
WScript.Echo "PNPDeviceID: " & objItem.PNPDeviceID
strPowerManagementCapabilities = Join(objItem.PowerManagementCapabilities, ",")
WScript.Echo "PowerManagementCapabilities: " & strPowerManagementCapabilities
WScript.Echo "PowerManagementSupported: " & objItem.PowerManagementSupported
WScript.Echo "ProcessorId: " & objItem.ProcessorId
WScript.Echo "ProcessorType: " & objItem.ProcessorType
WScript.Echo "Revision: " & objItem.Revision
WScript.Echo "Role: " & objItem.Role
WScript.Echo "SocketDesignation: " & objItem.SocketDesignation
WScript.Echo "Status: " & objItem.Status
WScript.Echo "StatusInfo: " & objItem.StatusInfo
WScript.Echo "Stepping: " & objItem.Stepping
WScript.Echo "SystemCreationClassName: " & objItem.SystemCreationClassName
WScript.Echo "SystemName: " & objItem.SystemName
WScript.Echo "UniqueId: " & objItem.UniqueId
WScript.Echo "UpgradeMethod: " & objItem.UpgradeMethod
WScript.Echo "Version: " & objItem.Version
WScript.Echo "VoltageCaps: " & objItem.VoltageCaps
WScript.Echo
Next
Next

Function WMIDateStringToDate(dtmDate)
WScript.Echo dtm:
WMIDateStringToDate = CDate(Mid(dtmDate, 5, 2) & "/" & _
Mid(dtmDate, 7, 2) & "/" & Left(dtmDate, 4) _
& " " & Mid (dtmDate, 9, 2) & ":" & Mid(dtmDate, 11, 2) & ":" & Mid(dtmDate,13, 2))
End Function

Adding a Printer on a Remote Computer

2008-01-19T21:39:00.000-08:00

These two scripts will add an IP port and install a printer on a remote machine. This is good to add a local IP printer on a remote workstation. For this script, you need to install prnadmin.dll. The prnadmin.dll file is available in the Windows Server 2003 Resource Kit Tools.

Add an IP port:
'----------------------------
'http://vbsbob.blogspot.com/
'Required files:prnadmin.dll
'prnadmin.dll is available
'in the Windows Resource Kit located
'at http://www.microsoft.com
'----------------------------

dim oPort
dim oMaster
set oPort = CreateObject("Port.Port.1")
set oMaster = CreateObject("PrintMaster.PrintMaster.1")
Set WshShell = WScript.CreateObject("WScript.Shell")

'Edit for comouter name
strMachineName = "\\computer"

'Edit for IP port name
strPortName = "Name of the Port"

'Edit for IP address
strIPAdress = "Insert Printer IP Address Here"

'Indicate where to add the port. Double quotes ("" ) stand for the local computer, which is the default.
oPort.ServerName = strMachineName

'The name of the port cannot be omitted.
oPort.PortName = strPortName

'The type of the port can be 1 (TCP RAW), 2 (TCP LPR), or 3 (standard local).
oPort.PortType = 1

'Mandatory for TCP ports. This is the address of the device to which the port connects.
oPort.HostAddress = strIPAdress

'For TCP RAW ports. Default is 9100.
oPort.PortNumber = 9100

'Enable or disable SNMP.
oPort.SNMP = false

'Applies to TCP LPR name, default is LPR
oPort.QueueName = "Queue"

'Byte counting or double spool applies to TCP LPR ports, is disabled by default.
oPort.DoubleSpool = false

'Try adding the port.
oMaster.PortAdd oPort
'Test for the status.
If Err <> 0 then

'An error occurred.
WshShell.Popup "Error " & Return & " returned during setup.", 10, "Printer port add.", 16
end if

WshShell.Popup "IP Port Add Successful", 10, "Install Status", 64

Add a Printer on a Remote Computer:

'----------------------------
'http://vbsbob.blogspot.com/
'Required files:prnadmin.dll
'prnadmin.dll is available
'in the Windows Resource Kit located
'at http://www.microsoft.com
'----------------------------

dim oMaster
dim oPrinter
Set WshShell = WScript.CreateObject("WScript.Shell")
set oMaster = CreateObject("PrintMaster.PrintMaster.1")
set oPrinter = CreateObject("Printer.Printer.1")

'Edit for Computer Name
'name of computer you want to add IP port to
strMachineName = "enter computer name here"

'Edit for Printer Name. This is the name users will see when selecting this printer
strPrinterName = "printer display name"

'Edit for Printer Driver Name. This specifies the printer driver to use.
'This must match the print driver name exactly.
'The string is required and cannot be empty.
'Example below is for the HP LaserJet 9040 Post Script
strDriverName = "HP LaserJet 9040 PS"

'Edit for the IP Port Name
'change aaa.bbb.ccc.ddd with the IP address of the printer
strPortName = "IP_aaa.bbb.ccc.ddd"

'Edit for the Driver Path.
'Where you unzipped the printer driver files to.
strDriverPath = "\\computer name\share name\"

'Edit for the INF path. Usually the same as the driver path plus the INF file
'point to where you unzipped the driver files
strINF = "\\computer name\share name\HP LaserJet 9040 PS.inf"

oPrinter.ServerName = strMachineName
oPrinter.PrinterName = strPrinterName
oPrinter.DriverName = strDriverName
oPrinter.PortName = strPortName
oPrinter.DriverPath = strDriverPath
oPrinter.InfFile = strINF

'The following code adds the printer.
oMaster.PrinterAdd oPrinter

'The following code uses the Err object to determine whether the printer was added successfully.
if Err <> 0 then
'An error occurred
WshShell.Popup "Error " & Return & " returned during setup.", 10, "Printer add.", 16
end if

WshShell.Popup "Printer Add Successful", 10, "Install Status", 64

Sending Email from A VBScript

2008-01-14T14:14:00.000-08:00

You can add this code to your scripts to send an email.

Dim strComputer, sTextBody, objEmail, strSMTPServer, strFrom, strTo, strSubject, strTextbody

strSMTPServer = "enter the smtp server here"
strFrom = "enter the from email address here"
strTo = "enter the to email address here"
strSubject = "enter the email subject here"
strTextbody = "enter the body of the email here"

Set objEmail = CreateObject("CDO.Message")
objEmail.From = strFrom
objEmail.To = strTo
objEmail.Subject = strSubject
objEmail.Textbody = strTextbody
objEmail.AddAttachment "to add an attachment to the email, type in the file path"
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTPServer
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objEmail.Configuration.Fields.Update
objEmail.Send

Set objEmail = Nothing

Cool Tech Toys, Gadgets, and Apparel

2008-01-12T18:32:00.000-08:00

http://www.thinkgeek.com/

Cool toys, gadgets, and apparel for techies.

My favorite...

Palmsize R/C Helicopter

Enable or Disable Remote Desktop on Multiple Computers

2008-01-10T15:03:00.000-08:00

This script will enable or disable Remote Desktop on multiple computers on an IP segment. The first input box asks for the subnet (i.e. 192.168.1). The second input box asks for the lowest number on the segment that you would like to start with. The third box asks for the highest number on the segment that you want to end with. I would like to add more to this script that will allow it to ping an IP address first. If there is no response it will move on to the next address instead of trying to enable RD on a non-existent PC. I will add that when I have time.

'http://vbsbob.blogspot.com/
DIM strComputer, strIPInput, strLow, strHigh
On Error Resume Next
Set WshShell = WScript.CreateObject("WScript.Shell")

'Set to 0 to disable Remote Desktop, set to 1 to enable Remote Desktop
Const ENABLE_CONNECTIONS = 1

strIPInput = InputBox("What is the subnet? Format as XX.YY.ZZ.")
strLow = InputBox("What is the low address in the range?")
strHigh = InputBox("What is the highest address in the range?")

If Right(strIPInput,1) <> "." Then
strIPInput = strIPInput & "."
End If

If strIPInput = "" OR strLow = "" OR strHigh = "" OR strHigh > 254 Then
Wscript.Echo "Invalid input - Script Cancelled"
wscript.Quit
End If

For i = strLow to strHigh

strComputer = strIPInput & i

Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}\\" & strComputer & "\root\cimv2")

Set colItems = objWMIService.ExecQuery ("Select * from Win32_TerminalServiceSetting")

For Each objItem in colItems
errResult = objItem.SetAllowTSConnections(ENABLE_CONNECTIONS)
Next
Next

WshShell.Popup "Complete", 10, "Remote Desktop Status", 64

Adding Network Printers Using a VBS Script

2008-01-06T12:31:00.000-08:00

This script will install network printers for users that are a member of a specified security group. You can run this from the user's login script.

'http://vbsbob.blogspot.com/
Dim shellobj, netobj, username, adsobj

On Error Resume Next

Set shellobj = WScript.CreateObject("WScript.Shell")
Set netobj = WScript.CreateObject("WScript.Network")

While username = ""
username = netobj.UserName
Wend

adsPath = "WinNT://Active Directory Domain Name/" & username
Set adsobj = GetObject(adsPath)

For Each Prop IN adsobj.Groups
Select Case Prop.Name

Case "security group"
netobj.AddWindowsPrinterConnection "\\server name\printer share name"

Create a Desktop Shortcut on the All Users Desktop

2008-01-05T11:16:00.000-08:00

This script will create a shortcut on the All Users Desktop.

'VBSBOB
'http://vbsbob.blogspot.com/
'Define the All Users desktop file path.
allusersdesktop = "C:\Documents and Settings\All Users\Desktop"

set WshShell = WScript.CreateObject("WScript.Shell")
set oShellLink = WshShell.CreateShortcut(allusersdesktop & "\VBSBob.lnk")
'Define where you would like the shortcut to point to. This can be a program, Web site, etc.
oShellLink.TargetPath = "http://vbsbob.blogspot.com"
oShellLink.WindowStyle = 1
'Define what icon the shortcut should use. Here we use the explorer.exe icon.
oShellLink.IconLocation = "C:\WINDOWS\explorer.exe"
oShellLink.Description = "VBSBob"
oShellLink.WorkingDirectory = allusersdesktop
oShellLink.Save

VBS Reference

2008-01-05T02:07:00.000-08:00

VBS Site Links:
http://www.microsoft.com/technet/scriptcenter/hubs/start.mspx

Lock Workstation

2008-01-05T00:52:00.000-08:00

Hi,

I am going to start things off easy. Here is a script I created that will automatically lock a workstation. If you do not know how to create a VBS script, stay tuned. I will post a basic tutorial on creating VBS scripts. Anyway, here is the script; start your copy at 'VBSBOB:

'VBSBOB
'http://vbsbob.blogspot.com/
On Error Resume Next

Set objShell = CreateObject("Wscript.Shell")
objShell.Run "%windir%\System32\rundll32.exe user32.dll,LockWorkStation"