[HPADM] SUMMARY: Extract a sliding 7 day window of data from MeasureWare.

From: Edwards, John O (john.o.edwards@boeing.com)
Date: Thu Sep 25 2003 - 23:41:16 EDT

Thanks to both Alan Riggs and Richard Wright who both pointed out the "-b" option.

Alan Riggs:
The basic flags you are looking for are: '-b "TODAY-7" and '-e "TODAY-1"'
A special thanks to Alan for supplying an example script so that I could also see the option in context.

Richard Wright:
Use "-b last-7"

-john

-----Original Message-----
From: Edwards, John O [mailto:john.o.edwards@boeing.com]
Sent: Thursday, September 25, 2003 8:00 AM
To: hpux-admin@dutchworks.nl
Subject: [HPADM] Extract a sliding 7 day window of data from MeasureWare.

I would like to extract data from the MeasureWare logs using a sliding seven day window. e.g. daily extract "yesterday-7"(inclusive-7days of data). I have tried various permutations of day-7(not inclusive, one day only), last-7,etc.

Here is how I am performing the extract currently:

#!/usr/bin/sh

extract -v \
                -xp week-1 \
            -s 07:00 - 17:00 \
            -AGDN \
            -r report.rpt \
            -f extract.dat

### eof test.extract ###

I do not wish to be limited to a Monday-Sunday week (the default for week-1). Using cron on Monday, I would like to see the previous Monday through Sunday. On Tuesday, I would like to see the previous Tuesday through Monday, etc.

Thanks in advance,

-john 

---
John O. Edwards
--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)

This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:34 EDT