I've got a script that runs every morning at 6am to ping and trace each server on our network and then sends the output to a text file. Now, what I want to do is to convert this data into a database (MS Access, MS Excel, or any other you can point me in the direction of). What I am looking to do with this script is to take the IP/server name and time:
(ex: 10.60.1.4 and 26ms) from a line like this
Reply from 10.60.1.4: bytes=32 time=26ms TTL=123
the number of packets sent/received plus the % lost and the averages from below
Ping statistics for 10.20.1.23:
Packets: Sent = 25, Received = 25, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 18ms, Maximum = 68ms, Average = 31ms
and input them into the table/database so we can keep track of the fluctuation in times. Also, for the trace routes I am looking to see if there were any Request time outs and if so, how many. This might be too specific of a task but we've had some issues with the ISP lately and this would be very helpful.
I guess my question would be, is there any way to pick out exactly what you need from the text file and insert it into a database/spreadsheet if the text is random like a ping/tracert is?