Vb script for a task

[siri]

Hi All,



need help on a vb script

task:

1. we have an excel of 2 columns onw with host name and 2 with Ip Adress
2.Write a code ns lokkup host name in CMd prompt and get the Ip adress
3. COmpare the 2 ip adresses
4.iff the IP macthces then true msg box or esle false

[Saket]

You can use wscipt.shell to execute the command and get the output using stdout.readall method.
here is some guidelines you can use -
1. get the host name and ip address from excel
2. Execute the ns lookup command with the returned host name
3. Get the output with stdout
4. Parse the ip address and compare

[siri]

thanks saket .

can u let me know any sample code
I tried recording through QTP but the C command prompt are not captured by QTP

[Saket]

Code:

Set oWshShell = CreateObject("wscript.Shell")
sCmd = "nslookup .." 'put your command here

Set oExec = oWshShell.Exec(sCmd)
sStdout = oExec.StdOut.ReadAll
sStdErr = oExec.StdErr.ReadAll

MsgBox "stdout: " & sStdout &  " stderr: " & sStderr

let me know if this helps