WISDOMBAY

WINDOWS SCRIPTING CORNER @ WISDOMBAY

A periodic Section maintained by Pramod S Nair

17. A Windows Script that deals with the output from a shell command

Posted on WisdomBay @ 7:02 PM 06-04-2006 | Post by Pramod S Nair

This script can be used to get the output of a shell command back into the script itself. This script can be modified by the admins for executing external commands or applications and to read it's output back in to the script for further processing.

'A Windows Script that deals with the output from a shell command 'This example deals in finding the Ip address of the machine by parsing the output of ipconfig command 'Compiled by Pramod S Nair 'http://www.wisdombay.com 'Written 4:15 PM 04/05/2006 Dim objWshShell Dim objEx dim intInterfaceNo Set objWshShell = CreateObject("WScript.Shell") 'We are going to execute the ipconfig command in a cmd shell launched with /c param. so it quits after execution strToExec = "cmd /c ipconfig " ' and in it's output we are looking for a line that begins with IP Address strToFind = "IP Address" intInterfaceNo = 1 'Make an Exec Obj Set objEx = objWshShell.Exec(strToExec) 'Now go through the output from the shell command and weed out the line in which we are interested Do While objEx.StdOut.AtEndOfStream <> True 'get current line strCurLine = objEx.StdOut.ReadLine 'check if the line is the one we are looking for If InStr(strCurLine,strToFind) Then 'We found our line in which the ip address is residing after a : symbol. 'So just cut the string at : symbol and take the part that comes after the : symbol. it will 'be the ip address. strAr = split(strCurLine,":") WScript.Echo "IP Address of Interface number " & intInterfaceNo & " of this Machine is : " & strAr(1) intInterfaceNo = intInterfaceNo +1 End If Loop 'End of Script

How to use :
1. Copy the code given above to clipboard.
2. Create a new file and name it as you like with a '.vbs' extension.
3. Now you can use this script for executing any exteranl command or app from your script and then process the output of the command from the script itself.