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
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Free, graphical schedule management tools?, Daniel Swan/TM
- Re: Free, graphical schedule management tools?, Talafous, John G.
- Re: Free, graphical schedule management tools?, Robert Cross
- Re: Free, graphical schedule management tools?, Richard Cowen
- Re: Free, graphical schedule management tools?, Doherty, John (ANFIS)
- Re: Free, graphical schedule management tools?, Tectrade Computers
- Re: Free, graphical schedule management tools?, Viswanathan, Ramesh (CNA)
- Re: Free, graphical schedule management tools?, Richard Cowen
- Re: Free, graphical schedule management tools?,
Cook, Dwight E <=
- Re: Free, graphical schedule management tools?, Bart Colbert
- Re: Free, graphical schedule management tools?, Mr. Lindsay Morris
|
|
|