We use something similar, but only report on client errors (for this particular report).
select MESSAGE,DOMAINNAME,NODENAME,DATE_TIME from actlog where - date_time>current_timestamp - 1 days and originator='CLIENT' AND SEVERITY='E' - ORDER BY DOMAINNAME,NODENAME Also something to check is for message ANE4959I when the number <> 0: 04/16/2002 04:53:49 ANE4959I (Session: 3380, Node: XXXXXXXXX) Total number of objects failed: 2 I've seen a NetWare client have failed objects (NDS objects failed) with no other errors logged to server, only way to catch this is via this message or scan local client error\schedule logs. Tim Rushforth City of Winnipeg -----Original Message----- From: Jim Healy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Re: Daily Backup Report try this , I use this as a startingpoint to search for failures SELECT ACTLOG.DATE_TIME, ACTLOG.MESSAGE, ACTLOG.SEVERITY FROM ACTLOG ACTLOG WHERE (ACTLOG.SEVERITY='E') and (ACTLOG.DATE_TIME>{ts (current date -1 day, '21:00:00')}) "Joseph Dawes" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 04/16/2002 03:34:23 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Daily Backup Report so how do you track failures
