Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am the sys administrator for a very big network. Each time one of
the computers is restarted on my network a small DOS batch file runs. The first part of this DOS batch file updates a specific directory's exe's with the newest versions from a shared network directory. The second part of this batch file updates a central text file. I can then check this text file to make sure that all the computers have been updated on my network. Here is an example of the text file: (TESTAAA.txt) -------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- THE DATE: 2007/03/01 ----------- THE TIME: 13:59 ----------- THE COMPUTER BEING SYNCHRONIZED: Windows IP Configuration Host Name . . . . . . . . . . . . : cpf8-wks Primary Dns Suffix . . . . . . . : tantis.local Node Type . . . . . . . . . . . . : Unknown IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No DNS Suffix Search List. . . . . . : tantis.local Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.11.191 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.11.1 DHCP Class ID . . . . . . . . . . : Internet Users DNS Servers . . . . . . . . . . . : 192.168.11.155 192.168.11.175 -------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- THE DATE: 2007/03/01 ----------- THE TIME: 14:01 ----------- THE COMPUTER BEING SYNCHRONIZED: Windows IP Configuration Host Name . . . . . . . . . . . . : cpf1-wks Primary Dns Suffix . . . . . . . : tantis.local Node Type . . . . . . . . . . . . : Unknown IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No DNS Suffix Search List. . . . . . : tantis.local Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller Physical Address. . . . . . . . . : 00-14-22-5F-25-E0 Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.11.214 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.11.1 DNS Servers . . . . . . . . . . . : 192.168.11.155 192.168.11.175 -------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- THE DATE: 2007/03/01 ----------- THE TIME: 15:19 ----------- THE COMPUTER BEING SYNCHRONIZED: Windows IP Configuration Host Name . . . . . . . . . . . . : cpf8-wks Primary Dns Suffix . . . . . . . : tantis.local Node Type . . . . . . . . . . . . : Unknown IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No DNS Suffix Search List. . . . . . : tantis.local Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.11.191 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.11.1 DHCP Class ID . . . . . . . . . . : Internet Users DNS Servers . . . . . . . . . . . : 192.168.11.155 192.168.11.175 -------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- THE DATE: 2007/03/01 ----------- THE TIME: 15:19 ----------- THE COMPUTER BEING SYNCHRONIZED: Windows IP Configuration Host Name . . . . . . . . . . . . : cpf8-wks Primary Dns Suffix . . . . . . . : tantis.local Node Type . . . . . . . . . . . . : Unknown IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No DNS Suffix Search List. . . . . . : tantis.local Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.11.191 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.11.1 DHCP Class ID . . . . . . . . . . : Internet Users DNS Servers . . . . . . . . . . . : 192.168.11.155 192.168.11.175 -------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- THE DATE: 2007/03/01 ----------- THE TIME: 15:19 ----------- THE COMPUTER BEING SYNCHRONIZED: Windows IP Configuration Host Name . . . . . . . . . . . . : cpf3-wks Primary Dns Suffix . . . . . . . : tantis.local Node Type . . . . . . . . . . . . : Unknown IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No DNS Suffix Search List. . . . . . : tantis.local Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Broadcom NetXtreme 57xx Gigabit Controller Physical Address. . . . . . . . . : 00-13-72-70-2F-25 Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.11.196 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.11.1 DNS Servers . . . . . . . . . . . : 192.168.11.155 192.168.11.175 It is clear that the same information gets received from the computers and gets repeated. My question is this: I would like to be able to get only the critical information in table form. For example: Date Time IP Host Name 2007/03/01 13:59 192.168.11.1 cpf3-wks 2007/03/01 14:10 192.168.11.3 cpf7-wks 2007/03/01 14:30 192.168.11.18 cpf2-wks If somebody can assist me in having a way to generate this report automatically from a program I would be very very gratefull!!! PLEASE HELP ME!!! Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Converted to a Picture | Excel Discussion (Misc queries) | |||
Text data being converted to Scientic Notation | Excel Worksheet Functions | |||
Converted data to labels. The 0 in zip codes does not print | New Users to Excel | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) |