Sponsored Content
Top Forums Shell Programming and Scripting SQL query output convert to HTML & send as email body Post 302884405 by Scott on Monday 20th of January 2014 08:18:15 AM
Old 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

We need a script that invokes the sql query every 14 days ans send email

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

We need a script that invokes the sql query every 14 days ans send email

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

Send HTML body and HTML attachment using MUTT command

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

Script to send email after comparing the folder permissions to a certain permission & send email

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

Email with multiple attachments & HTML body

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

Mutt for html body and multiple html & pdf attachments

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

Email body not formatted with html and sendmail

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

Shell scripting unable to send the sql query data in table in body of email

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

HTML table in email body using C Shell

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

Sending sql output to email body with conditional subject line

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
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)
All times are GMT -4. The time now is 01:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy