I have created a script which mails me the hardware info for each server i have, now i need to put all this info in an xls sheet which can be a pain, would this be possible through a script?
"======= HOSTNAME ========="
Host Name: servername
"===== IP ADDRESSES ========"
IP Address. . . . . . . . . . . . : x.x.x.x
IP Address. . . . . . . . . . . . : x.x.x.x
"===== CPU INFO ========"
[01]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[02]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[03]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[04]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[05]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[06]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[07]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[08]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[01]: Intel(R) PRO/1000 MT Network Connection
Processor(s): 8 Processor(s) Installed.
"===== MEMORY ========"
Total Physical Memory: 8,191 MB
"===== TOTAL DISK ON SERVER ========"
Microsoft DiskPart version 5.2.3790.3959
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: servername
Disk ### Status Size Free Dyn Gpt
-------- ---------- ------- ------- --- ---
Disk 0 Online 68 GB 8033 KB
Disk 1 Online 838 GB 0 B
"===== RAID DISK INFORMATION IN SHORT ========"
Size : 68.24 GB (73274490880 bytes)
Size : 838.13 GB (899929866240 bytes)
Layout : RAID-1
Layout : RAID-10
"===== RAID DISK INFORMATION IN DETAILS ========"
Capacity : 68.24 GB (73274490880 bytes)
Capacity : 68.24 GB (73274490880 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
"===== O/S RELEASE ========"
OS Name: Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition