ADSM-L

Re: Free, graphical schedule management tools?

2000-07-10 10:19:27
Subject: Re: Free, graphical schedule management tools?
From: "Cook, Dwight E" <cookde AT BP DOT COM>
Date: Mon, 10 Jul 2000 09:19:27 -0500
Now you know what really sucks is that the accounting records have an "end
time" and a "duration" and to really plot things out a start date & time is
helpful...
well...  how 'bout STARTT mm/dd/yyyy hh:mm:ss dursec
where the month day year hour minutes & seconds are an "end time" and the
dursec is a duration in seconds...
 > startt 01/01/2000 00:10:00 700
inputs 01/01/2000 00:10:00 700
rundays 0 runhrs 0 runmins 11 runsec 40
started 12/31/1999 23:58:20

Note in my little test it is even Y2K compliant ;-)

I'm sure there is about a billion ways better to do this but I needed to do
this on a few items so I threw this together...
Oh, hope folks have a "unix" environment to use this under ;-)

#!/bin/ksh
# takes a date & time input in the form mm/dd/yyyy HH:MM:SS SSSS
# and calculates the initial time by subtracting SSSS from HH:MM:SS
ENDmm=$(echo $1 | cut -d'/' -f1)
ENDdd=$(echo $1 | cut -d'/' -f2)
ENDyyyy=$(echo $1 | cut -d'/' -f3)
ENDHH=$(echo $2 | cut -d':' -f1)
ENDMM=$(echo $2 | cut -d':' -f2)
ENDSS=$(echo $2 | cut -d':' -f3)
ENDSSSS=$3
let RUNHH=ENDSSSS/3600
let RUNMM=ENDSSSS%3600/60
let RUNSS=ENDSSSS-RUNHH*3600-RUNMM*60
let RUNDAYS=RUNHH/24
if [ $RUNDAYS -gt 0 ] ; then
   let RUNHH=RUNHH-RUNDAYS*24
fi
if [ $RUNSS -le $ENDSS ] ; then
   let STARTSS=ENDSS-RUNSS
else
   let STARTSS=ENDSS+60-RUNSS
   let ENDMM=ENDMM-1
fi
if [ $RUNMM -le $ENDMM ] ; then
   let STARTMM=ENDMM-RUNMM
else
   let STARTMM=ENDMM+60-RUNMM
   let ENDHH=ENDHH-1
fi
if [ $RUNHH -le $ENDHH ] ; then
   let STARTHH=ENDHH-RUNHH
else
   let STARTHH=ENDHH+24-RUNHH
   let ENDdd=ENDdd-1
fi
let STARTdd=ENDdd-RUNDAYS
# this assumes that no process runs over 2 days !
STARTmm=$ENDmm
STARTyyyy=$ENDyyyy
if [ $STARTdd -le 0 ] ; then
   case $STARTmm in
        01)     STARTmm=12
                let "STARTyyyy=STARTyyyy-1";;
        02)     STARTmm=01;;
        03)     STARTmm=02;;
        04)     STARTmm=03;;
        05)     STARTmm=04;;
        06)     STARTmm=05;;
        07)     STARTmm=06;;
        08)     STARTmm=07;;
        09)     STARTmm=08;;
        10)     STARTmm=09;;
        11)     STARTmm=10;;
        12)     STARTmm=11;;
   esac
   for STARTdd in $(cal $STARTmm $STARTyyyy | grep [0-9] | tail -n1)
      do
      echo $STARTdd > /dev/null
      done
fi
echo inputs $1 $2 $3
echo rundays $RUNDAYS runhrs $RUNHH runmins $RUNMM runsec $RUNSS
echo started $STARTmm/$STARTdd/$STARTyyyy $STARTHH:$STARTMM:$STARTSS
exit



> ----------
> From:         Robert Cross[SMTP:Robert.Cross AT SCOTTISH-NEWCASTLE.CO DOT UK]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Monday, July 10, 2000 8:02 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Free, graphical schedule management tools?
>
> Daniel Swan wrote:
> >I'm trying to load balance my backups over time, but it would help if I
> had
> >a visual representation of what backups start when, and how long they
> take,
> >somewhat like a Gant Chart.
> >Is there any free tool to automatically read one's ADSM schedules, and
> >output a nice graphical representation?
>
> I'd be interested in hearing of any such tools as well, since it's a
> problem
> that
> we're finding as well.
>
> At the moment, the best we've got is a Visio smart drawing that I cobbled
> together
> in a spare five minutes.
> All the data has to be entered manually since to do otherwise would
> require more
> knowledge of VBA/ODBC than I have at the moment ( = 0 ).
>
> I'm now thinking that a nice Perl script using the Perl/Tk  or GD/Graph
> modules
> would
> be a way better solution, (cross platform for a start). I'll probably have
> a go
> at that
> when work permits. [or should we all drop a BIG hint to Tivoli ;-) ]
>
> Failing that, anyone know of a tool that allows time-based bar charts on
> hour/minute
> scales? Microsoft Project doesn't appear to.
>
> Regards
>
> Bob Cross.
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> This message is confidential.  It may also be privileged or
> protected by other legal rules.  It does not constitute an
> offer or acceptance of an offer, nor shall it form any part
> of a legally binding contract.  If you have received this
> communication in error, please let us know by reply then
> destroy it.  You should not use, print, copy the message or
> disclose its contents to anyone.
>
> E-mail is subject to possible data corruption, is not
> secure, and its content does not necessarily represent the
> opinion of this Company.  No representation or warranty is
> made as to the accuracy or completeness of the information
> and no liability can be accepted for any loss arising from
> its use.
>
> This e-mail and any attachments are not guaranteed to be
> free from so-called computer viruses and it is recommended
> that you check for such viruses before down-loading it to
> your computer equipment.  This Company has no control over
> other websites to which there may be hypertext links and no
> liability can be accepted in relation to those sites.
>
> Scottish & Newcastle plc
> Registered in Scotland, Registered Number 16288
> Registered Office: 50 East Fettes Avenue, Edinburgh, EH4 1RR
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>