01-20-2014
It depends which database system you are using.
In MySQL, you can use the -H (or --html) option. In Oracle SQLPlus, you can use set markup html on.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies
2. Shell Programming and Scripting
HI,
We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies
3. Red Hat
Hi there..
I need a proper "mutt" command to send a mail with html body and html attachment at a time.
Also if possible let me know the other commands to do this task.
Please help me.. (2 Replies)
Discussion started by: vickramshetty
2 Replies
4. Shell Programming and Scripting
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies
5. UNIX for Advanced & Expert Users
I have a html file:
# cat sample.html
<html>
<body>
Sample HTML file</p>
</body>
</html>
And I have two excel sheets (sheet1.xls & sheet2.xls)
I want to send an email by having the sample.html as the message body and two spreadsheets as the attachments.
I tried using the below command:... (12 Replies)
Discussion started by: BHM
12 Replies
6. UNIX for Advanced & Expert Users
Hi all:
Been racking my brain on this for the last couple of days and what has been most frustrating is that this is the last piece I need to complete a project.
There are numerous posts discussing mutt in this forum and others but I have been unable to find similar issues.
Running with... (1 Reply)
Discussion started by: raggmopp
1 Replies
7. Shell Programming and Scripting
Hi All,
I am trying to send the contents of a file as email body. I am using html email and sendmail option of unix. I am using the below piece of code for the same :
#!/usr/bin/ksh
export MAILTO="email@domain.com"
export SUBJECT="Report"
export BODY="file_directory_path/test_file.txt"... (1 Reply)
Discussion started by: rockygsd
1 Replies
8. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
9. Shell Programming and Scripting
I am using Sun Solaris ver. 5.10 and trying to send an HTML table in email body using mail command in C shell script.
I tried following commands:-
#1
mail -m "MIME-Version: 1.0;Content-type:text/html;charset=UTF-8" receiver@mail.com < file.html #2
mail -m "Content-type: text/html;" -s "This... (4 Replies)
Discussion started by: jnrohit2k
4 Replies
10. Shell Programming and Scripting
hi ,
i have written below piece of code to meet the requirement but i am stuck in the logic here.
the requirement are:
1) to send the sql out put to email body with proper formatting.
2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Discussion started by: itzkashi
10 Replies
LEARN ABOUT DEBIAN
lr_log2mail
LR_LOG2MAIL.IN(1) LogReport's Lire Documentation LR_LOG2MAIL.IN(1)
NAME
lr_log2mail - send a report generated from a log file by email
SYNOPSIS
lr_log2mail [options] service addresses...
lr_log2report --version
lr_log2report --help [dlf-converters|output-formats|report-templates]
OPTIONS
--help [section]
If no argument is given, prints usage information and exits. Argument can be one of the following:
dlf-converters
Prints the list of available DLF converters and exits.
output-formats
Prints the list of available output formats and exits.
report-templates
Prints the list of available report templates and exits.
--version
Prints Lire's version and exits.
--output-format|-o output format
Selects the ouput format in which to generate the report.
--template name
Uses the report configuration named name to generate the report.
--log-file logfile
Selects the log file that should be processed instead of STDIN.
--subject|-s subject
Sets the subject of the email message. Defaults to 'Your format report'.
--extra-file file
An additional text file that will be sent along the report. If the output format is txt, it will be appended to the report.
DESCRIPTION
The lr_log2mail command is similar to the lr_log2report(1) command with the difference that the report is sent by email. The log file is
read from STDIN or from the file specified using the --log-file option. The format of the log file is specified using the dlf_converter
argument. Use the --help-dlf-converters option to get a list of all currently available DLF converters. All remaining arguments are
interpreted as email addresses to which to send the report. In case the log is passed in a compressed format, it's uncompressed on the fly,
using gzip(1).
The report will be encapsulated in a MIME email appropriate for the output format. For example, ASCII reports will be sent inline, PDF
reports will be sent as a file attachment and HTML reports should appear inline in a HTML-capable mail reader.
The From and Reply-To headers in the outgoing emails are set to the values of the lr_mail_from and lr_mail_replyto configuration variables.
EXAMPLE
% lr_log2mail -s "bind8 report" bind8_query
root "Joe User <joe@example.com>" < /var/log/query.log
SEE ALSO
lr_log2report(1), lr_xml2report(1), lr_xml2mail(1), lire(1), lire(7), documentation in the Lire User Manual
AUTHORS
Joost van Baal <joostvb@logreport.org>
Francis J. Lacoste <flacoste@logreport.org>
VERSION
$Id: lr_log2mail.in,v 1.60 2006/07/23 13:16:33 vanbaal Exp $
COPYRIGHT
Copyright (C) 2000-2004 Stichting LogReport Foundation LogReport@LogReport.org
This program is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2006-07-23 LR_LOG2MAIL.IN(1)