03-26-2008
Need to dump mailtest into a xls sheet
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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
2. HP-UX
Dear Members,
How do I create an eqvivalant of Excel sheet in Hp-UX.
Is there any application like the Microsoft Excel on HP-UX.
How do I invoke it.
Regards,
PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies
3. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls
Eno Ename
101 hello
102 hero
103 india
bbc.xls
Eno Ename
201 delhi
202 Hyd
203... (0 Replies)
Discussion started by: jagadish99
0 Replies
4. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls bbc.xls
Eno Ename Eno Ename
101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies
5. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
6. Solaris
Hello,
I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team.
I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies
7. Shell Programming and Scripting
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
8. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
9. Shell Programming and Scripting
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
10. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
LEARN ABOUT DEBIAN
dvbscan
dvbscan(1) General Commands Manual dvbscan(1)
NAME
dvbscan - a program to produce DVB-T channels.conf files.
SYNOPSIS
dvbscan [options]<initialscanfile>
DESCRIPTION
This manual page documents briefly the dvbscan commands.
dvbscan is a program to produce DVB-T channels.conf files.
OPTIONS
-h print this help text
-adapter <id>
adapter to use (default 0)
-frontend <id>
frontend to use (default 0)
-demux <id>
demux to use (default 0)
-secfile <filename>
Optional sec.conf file
-secid <secid>
ID of the SEC configuration to use, one of: * UNIVERSAL (default) - Europe, 10800 to 11800 MHz and 11600 to 12700 Mhz, Dual
LO, loband 9750, hiband 10600 MHz * DBS - Expressvu, North America, 12200 to 12700 MHz, Single LO, 11250 MHz * STANDARD -
10945 to 11450 Mhz, Single LO, 10000 Mhz * ENHANCED - Astra, 10700 to 11700 MHz, Single LO, 9750 MHz * C-BAND - Big Dish,
3700 to 4200 MHz, Single LO, 5150 Mhz * C-MULTI - Big Dish - Multipoint LNBf, 3700 to 4200 MHz, Dual LO, H:5150MHz, V:5750MHz
* One of the sec definitions from the secfile if supplied
-satpos <position>
Specify DISEQC switch position for DVB-S
-inversion <on|off|auto>
Specify inversion (default: auto)
-uk-ordering
Use UK DVB-T channel ordering if present.
-timeout <secs>
Specify filter timeout to use (standard specced values will be used by default)
-filter <filter>
Specify service filter, a comma seperated list of the following tokens: If no filter is supplied, all services will be output *
tv - Output TV channels * radio - Output radio channels * other - Output other channels * encrypted - Output
encrypted channels
-out raw <filename>|-
Output in raw format to <filename> or stdout -out channels <filename>|- Output in channels.conf format to <filename> or stdout -out
vdr12 <filename>|- Output in vdr 1.2.x format to <filename> or stdout -out vdr13 <filename>|- Output in vdr 1.3.x format to <file-
name> or stdout
This manual page was written by Uwe Bugla <uwe.bugla@gmx.de>.
February 14, 2009 dvbscan(1)