Hi



Try this select command

select d1.*, d2.end_time from events d1, summary d2 where d1.actual_sta         
rt=d2.start_time and d1.node_name=d2.entity



best regards,
Arni Snorri Eggertsson
arnie AT gormur DOT com

On Fri, Oct 04, 2002 at 01:02:52PM -0000, Petur Ey?orsson wrote:
> No you dont understand me.
>
> Im not looking for the Status Column. Im looking for the Completed Column.
> The Accutal time when the job finished.
>  :/
>
> Kvedja/Regards
> Petur Eythorsson
> Taeknimadur/Technician
> IBM Certified Specialist - AIX
> Tivoli Storage Manager Certified Professional
> Microsoft Certified System Engineer
>
> peddi AT itn DOT is
>
>  Nyherji Hf              Simi TEL: +354-569-7700
>  Borgartun 37            105 Iceland
>  URL:                    http://www.nyherji.is
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> David Stabler
> Sent: 4. oktober 2002 12:28
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Event Report
>
>
> I really hate doing this......
>
> >>> peddi AT ITN DOT IS 10/04/02 06:55AM >>>
>
> > If you do a q event * * begind f=d
> > [snip]
> >             Status: Completed
> > [snip]
> >
> > i can see a status there called Completed.
> >
> > But when i run the command select * from events
> > i cant see the column completed.
> > [snip]
> >          STATUS: Completed
>
> ^^^^^^^^^^^^^^^^^^^^^^^^
>
> > [snip]
> > Do anyone know where the column is?
>
> It's there.  It's called STATUS.  All caps may be why you're process is
> missing it.  Give it a try again.  It's there, even in the output in
> your email.
>
> -drs-