In a previous tip, you learned how to call PowerShell statements and read their return value. Return values are somewhat limited because they can only...
In a previous tip, you learned how to call PowerShell statements and read their return value. Return values are somewhat limited because they can only be numeric. There is an easy way to do this if you’d like to read more structured information from a PowerShell call and process the returned information within VBScript.
From within VBScript, simply use the WScript.Shell object and take advantage of the Exec() method, which can read console output from another application.Exec() can read this information and returns it to VBScript since PowerShell outputs all results to its console.
pscommand = ” get-service | Foreach-Object { $_.Name } “
cmd = “powershell.exe -noprofile -command “ & pscommand
Set shell = CreateObject(“WScript.Shell”)
Set executor = shell.Exec(cmd)
executor.StdIn.Close
MsgBox executor.StdOut.ReadAll
In this example, VBScript uses PowerShell to return a list of service names. But, of course, you could use just any PowerShell statement in the pscommand variable.
Contact our sales team to get a personalized demo of our database management software for SQL Server!
