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

From: Edwards, John O (john.o.edwards_at_boeing.com)
Date: 09/26/03

  • Next message: Unternaehrer Stefano: "[HPADM] [Summary] trashed stack" 
    Date: Thu, 25 Sep 2003 20:41:16 -0700
To: <hpux-admin@dutchworks.nl>

    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)
  • Next message: Unternaehrer Stefano: "[HPADM] [Summary] trashed stack"