Joel,

==>The 'query event ... exceptionsonly=yes' may be what you are looking
for.

can you explain a little bit more on your  suggestion.

Thanks.

Sandy


=======================================================================
Date:    Thu, 3 Dec 1998 12:23:45 -0800
From:    Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
Subject: Re: query client events
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

The 'query event ... exceptionsonly=yes' may be what you are looking for.

On Thu, 3 Dec 1998, Sandy Wu wrote:

> Hi  ADSMERS:
>
>  I have been using MS ACCESS to monitor my backup progress by querying
the
> actlog:
> for example
>
> SELECT * FROM ACTLOG WHERE SEVERITY='E'
>
>  This has been working fine except that I will miss the clients that have
> been powered off or have network problems, because in these cases  it
only > get  severity='I' with msgno=2578 from actlog.  I  normally have to
go into
> Web admin then click' query client events', from here it will show me a
> good report  with status "completed" or "missed" on each node_name.
>
> Can someone tell me what are those tables that this query queries from
when > you do  query client events? It seems to me this report comes from
multiple > tables. I would like to incorporate this into my odbc report
mechanism so I > don't have to jump around 2 separate places to do the
monitoring. (By the
> way I know I can edit my query and  incl. the msgno=2578 , but I really
> want to know where  are those tables  when doing "query client events"
from > the web admin utility.
>
>
>
> Thanks  in advance
>
>
> Sandy
>