MS-DOS Command Prompt questions

[Tuanisviet]

Hey folks!

First off, I don't know which section of the forum this needed to be so I put it in Windows since the majority of it is MS-DOS. Sorry if it's in the wrong section.


Now, I have a question, I'm trying to ping -a <IP_ADDRESS> a whole list of IP Addresses in command prompt then see if they are timing out or not and if they are timing out, return that results to a spreadsheet. Guys, I'm lost. I've been hearing I need to write a batch file, I need to write in C++, or get some kind of ultility tool to do it. Now, I can write a batch file to ping all these machines, but I don't know enough to know it has the ability to write back to a spreadsheet.

I come from a Java, JavaScript, and SQL background so I know little to noting about C++ and batch file creation. I know C++ is MUCH easier then Java to execute DOS commands, but I know Java can read from txt files and excel sheets for iteration lists like my thousands of IP addresses.

can anyone point me in the correct direction?

Thanks!

[udd]

I dun knw abt spread sheet but dis is how u do in notepad...

hope it'll b useful for u ..


::This is a .bat(batch) file
::To copy output of a IP which is being pinged
::Demo for a single IP address
:Welcome
::
@Echo off

ping 10.10.10.10 > tempfile.txt
copy /-y destfile.txt+te mpfile.txt destfile.txt

:: remember you need to first create the file destfile.txt
::repeat this for all ip's (you work on that:))
::ask me if this is not what you wanted

[Tuanisviet]

No, that's great. Thanks a lot.

Can you tell me how can I write to notepad to add comments or lines. I don't need ECHO., but something to print out onto the notepad per ping.

[epots9]

No, that's great. Thanks a lot.

Can you tell me how can I write to notepad to add comments or lines. I don't need ECHO., but something to print out onto the notepad per ping.

in the example echo is turned off so nothing is displaced and the output it stored in a text file called tempfile.

[udd]

::This is a .bat(batch) file
::To copy output of a IP which is being pinged
::Demo for a single IP address
:Welcome
::

@Echo off

Echo "This is a comment" >tempfile1.tx t
::Put comments on tempfile1.txt for each ping information

ping 10.10.10.10 > tempfile.txt
::The comment from tempfile1.txt is being copied to the tempfile.txt

copy /y tempfile.txt+te mpfile1.txt tempfile.txt

copy /y destfile.txt+te mpfile.txt destfile.txt

:: remember you need to first create the file destfile.txt
::repeat this for all ip's (you work on that:))
::ask me if this is not what you wanted



I hope u can use this idea,if not tell me,I would try to help it out...:)
Regards,
Yudi

[harshadd]

Well, Windows is always # include MSDOS so not to worry you are at right forum..

Now about your query, I have a small piece of bat file code, which checks if your ping is going through for a said IP address, I used vsnl's dns server IP to ping and check the status of my internet (whether it is Up /Down)
If "Ping to VSNL DNS is through, that means my NET is UP" is the logic
here is the code:It works with dos promt u obtain in XP by running cmd.exe NOT MS DOS 6.22 or lower (NOT TESTED ON 2000)

@echo off
set op= Lost = 0 (0%% loss)
:TOP
FOR /F "skip=9 usebackq tokens=3 delims=," %%i in (`ping
202.54.1.18`) do if "%op%"=="%% i" goto HND
ipconfig /release
ipconfig /renew
goto TOP
:HND
:EXIT

[Tuanisviet]

Well, Windows is always # include MSDOS so not to worry you are at right forum..

Now about your query, I have a small piece of bat file code, which checks if your ping is going through for a said IP address, I used vsnl's dns server IP to ping and check the status of my internet (whether it is Up /Down)
If "Ping to VSNL DNS is through, that means my NET is UP" is the logic
here is the code:It works with dos promt u obtain in XP by running cmd.exe NOT MS DOS 6.22 or lower (NOT TESTED ON 2000)

@echo off
set op= Lost = 0 (0%% loss)
:TOP
FOR /F "skip=9 usebackq tokens=3 delims=," %%i in (`ping
202.54.1.18`) do if "%op%"=="%% i" goto HND
ipconfig /release
ipconfig /renew
goto TOP
:HND
:EXIT

Sorry for late reply, but this works wonders. Thanks for everyone's posts. :D

[Aladdina]

If you just want to have a log file for the result, you may need to use PowerCmd. You can have your logs automatically saved when you run a command or batch script file.

[harshadd]

If you just want to have a log file for the result, you may need to use PowerCmd. You can have your logs automatically saved when you run a command or batch script file.

Aladdina, 99.99% ppl come on blogs to see FREE of cost solutions... It will be appreciated if you could provide/suggest FREE utilities as a solution.