Do the admin command 'q status' to be sure the "Event Record Retention
Period" is non-zero.

I use 8:00 AM to 8:00 AM as my processing day. So the command that I issue
to check for client problems is:

adsm> q ev * * begind=today-1 begint=08:00 endd=today endtime=07:59 ex=yes

Scheduled Start       Actual Start  Schedule Name Node Name     Status
--------------------  ------------  ------------- ------------- ---------
1998-12-03 20:00:00                 PM08          SERVER-A      Missed
1998-12-03 20:00:00                 PM08          SERVER-A      Missed
1998-12-03 21:00:00                 PM09          SERVER-B      Missed
1998-12-04 04:00:00                 AM04          NT-WS-102     Missed

I also check "Days Since Last Access" from a 'query node' command and if it
gets to large I email the client.

On Fri, 4 Dec 1998, Sandy Wu wrote:

> 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
> >
>