LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default TEXT and Data converted to only data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Converted to a Picture JM Excel Discussion (Misc queries) 0 January 12th 06 08:02 PM
Text data being converted to Scientic Notation Clark G. Excel Worksheet Functions 0 April 15th 05 01:49 PM
Converted data to labels. The 0 in zip codes does not print Judy New Users to Excel 2 February 2nd 05 03:33 AM
How do I import fractions without data being converted to dates? rproeber Excel Discussion (Misc queries) 1 December 6th 04 12:53 AM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"