Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: To get older than last 7days records using awk scripting to generate report and send email
Top Forums Shell Programming and Scripting To get older than last 7days records using awk scripting to generate report and send email Post 303000839 by RudiC on Thursday 20th of July 2017 03:12:35 PM
Old 07-20-2017
I'm afraid I can't. It was quite a mess to get the output in shape, and I couldn't test it with mail.
Try not to pipe it into sh, but analyse it on screen if the output makes sense. If it does, create a file of the same contents and have sh run it, mayhap with -xv options set. You may want to come back with results / errors so thes can be discussed here.

EDIT: looks like a partial line 1 days," was lost in dragging and dropping the script. Sorry for that - I counted double quotes incredibly often before it (almost) worked.
Last edited by RudiC; 07-20-2017 at 04:18 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Unable to send eMail from a UNIX-Host ( using mailx ) to a Outlook-email-addres(Win)

Hi A) I am able to send eMail using mailx from a UNIX ( solaris 8 ) host to my Outlook-email-ID : FName.Surname@Citigroup.com ( This is NOT my actual -eMail-ID). But in Outlook the "From :" eMail address is displayed as " usr1@unix-host1.unregistered.email.citicorp.com " .i.e the words... (2 Replies)
Discussion started by: Vetrivela
2 Replies

2. UNIX for Dummies Questions & Answers

awk to find the status and send an email

Hi, I have a datafile which has the following data and it can have much more records. The data set is as follows: ISA~00~ ~00~ ~ZZ~F159B ~ZZ~U1CAD ~051215~184 3~U~00200~000011432~0~P~< GS~FA~TC11A~U1CAD~051215~1843~000011432~X~002002 ST~997~0001... (6 Replies)
Discussion started by: isingh786
6 Replies

3. Shell Programming and Scripting

awk scripting - matching records and summing up time

Hello. I just found out about awk, and it appears that this could handle the problem I'm having right now. I first stumbled on the thread How to extract first and last line of different record from a file, and that problem is almost similar to mine. In my case, an ASCII file will contain the... (0 Replies)
Discussion started by: Gonik
0 Replies

4. Shell Programming and Scripting

How to generate sample records from a file

i have a file having 30 million records.i want to generate a file having say 5% of total records in another file. the records in the new file shud be randomly generated. (1 Reply)
Discussion started by: Nishithinfy
1 Replies

5. 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

6. UNIX for Dummies Questions & Answers

new to ldap, send email to a ou or group, and see a list from email client

hi, i'm running openldap on ubuntu 10.04, creating new items with apache directory studio (windows version). i use the ldap just as an address book to our small office (email clients are windows live mail 2009, 2011, microsoft outlook 2007 and 2010). a. i cant see a list of the contacts,... (0 Replies)
Discussion started by: V4705
0 Replies

7. Shell Programming and Scripting

Remove bad records from file and move them into a file then send those via email

Hi my requirement is that i want pull the bad records from input file and move those records in to a seperate file. that file has to be sent via email.. any suggentions please (1 Reply)
Discussion started by: sxk4999
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

Send email if latest file in a directory is older than 2 hours

I have a objective of Sending email if latest file in a directory(excluding files of sub-dirs) is older than 2 hours. eg : ls -ltr drwx--x--x 2 abcde abc 256 2017-02-07 20:10 Mail -rw-rw-r-- 1 abcde abc 1170 2017-02-24 17:30 test -rw-rw-r-- 1 abcde abc 356 2017-03-09 18:00 xyz.csv... (3 Replies)
Discussion started by: simpltyansh
3 Replies

10. UNIX for Beginners Questions & Answers

awk use to generate report

Hi , In a directory list of ddl files are stored in the given format above. Above is the sample ddl file. The ddl file name is same as that of table name ie email_notifications.ddl I want to generate below report using awk utility reading all the ddl files stored in /ddl path Desired output:... (1 Reply)
Discussion started by: vedanta
1 Replies

LEARN ABOUT DEBIAN

sparksimp

sparksimp(1)															      sparksimp(1)

NAME

       sparksimp - analyses all generated SPARK proof artifacts (in parallel)

SYNOPSIS

       sparksimp [OPTIONS] [-sargs SIMPLIFIER_OPTIONS] [-zargs ZOMBIESCOPE_OPTIONS] [-vargs VICTOR_OPTIONS]

DESCRIPTION

       sparksimp,  analyses  all  verification	conditions and dead path conjectures generated by the Examiner for SPARK and attempts to discharge
       them using the Simplifier, ZombieScope and ViCToR. If requested, this can be done in parallel.

       This manual page only summarises the sparksimp command-line flags, please refer to the full SPARKSimp manual for further information.

OPTIONS

       These options do not quite follow the usual GNU command line syntax as options start with a single dash instead of the usual two.

       -a     Processes all files, even if their time-stamp indicated that they have been previously analysed.

       -v     Displays version information.

       -V     Verbose output.

       -n     Dry run -- this prints only the list of files to analyse and then stops.

       -ns    Do not run the Simplifier.

       -nz    Do not run ZombieScope.

       -victor
	      Run ViCToR/Alt-Ergo on VCs left unproven by Simplifier.  If -ns is specified then this will run ViCToR on all VCs.

       -t, -r Sort vcg file by size and analyse the largest ones first. If -r is specified as well analyse the smallest ones first.

       -l     Log spadesimp and zombiescope output for each unit analysed to UNIT.log and UNIT.zsl respectively.

       -e     Echo all output to the screen; this option cannot be used in conjunction with -p.

       -p=N   Use N concurrent processes.

       -x=PATH
	      Specifies an alternative Simplifier executable.

       -z=PATH
	      Specifies an alternative ZombieScope executable.

       -sargs OPTIONS, -zargs OPTIONS, -vargs OPTIONS
	      Any options following one of these will be passed to directly to the Simplifier, ZombieScope  or	ViCToR	respectively.  Please  see
	      their manual pages or documentation for more information.

SEE ALSO

       spark(1), spadesimp(1), zombiescope(1), victor(1), pogs(1)

       sparkformat(1), sparkmake(1)

AUTHOR

       This  manual  page  was	written by Florian Schanda <florian.schanda@altran-praxis.com> for the Debian GNU/Linux system (but may be used by
       others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License,  Ver-
       sion 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover
       Texts.

								   22 March 2011						      sparksimp(1)
All times are GMT -4. The time now is 12:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy