Hi Eric,

I think this will be the only alternative we have left. I would prefer the
SQL method in order to simplify the script which then analyses the output of
the command. Query event brings splitted lines for instance. I will check if
I can improve the formatting of the output.

Thanks,

Rene Lambelet
Nestec SA - 55, Av. Nestle - CH-1800 Vevey
Tel: ++41'21'924'35'43 / Fax: ++41'21'924'45'89
E-Mail: rene.lambelet AT nestle DOT com



> -----Original Message-----
> From: Loon, E.J. van - SPLXM [SMTP:Eric-van.Loon AT KLM DOT NL]
> Sent: Tuesday, 1. December 1998 09:16
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: How to query for past events
>
> Hi Rene!
> If you can't do it using SQL, why don't you use the admin commandline
> interface with the command Q EVENT * * BEGINDATE=TODAY-1 ENDDATE=TODAY
> EX=Y
> for failed and missed backup events and the command Q EVENT *
> BEGINDATE=TODAY-1 ENDDATE=TODAY TYPE=ADMIN EX=Y for failed/missed
> administrative commands.
> Do not omit the ENDDATE parameter, you would expect ENDDATE=TODAY to be
> default, but if you don't specify it, you will not see last nights failed
> events...
> Kindest regards,
> Eric van Loon
>
> -----Original Message-----
> From: Lambelet,Rene,VEVEY,FC-SIL/INF. [mailto:Rene.Lambelet AT NESTLE DOT COM]
> Sent: Monday, November 30, 1998 15:54
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How to query for past events
>
>
> Hello,
>
> a simple question for most of you:
>
> how can I code an SQL query to get a list of my recent schedule events?
>
> I would like to list the Missed and Failed ones.
>
> I checked the list of adsm tables but could not find any about schedules
> events.
>
> Thanks,
>
> Rene Lambelet
> Nestec SA - 55, Av. Nestle - CH-1800 Vevey
> Tel: ++41'21'924'35'43 / Fax: ++41'21'924'45'89
> E-Mail: rene.lambelet AT nestle DOT com