What I just found on a website.  Thanks for the tips .. that helped me in my 
search.


http://www.lascon.co.uk/d005104.htm

How did last nights backups go?
  select Entity,Successful,Bytes,Examined,Affected,Failed
  from summary
  where activity='BACKUP'
   and cast((current_timestamp-start_time)hours
   as decimal(8,0)) < 24
  order by Entity'

To convert this to an exception report, add 

  and failed>0

at the end of the 'where' statement 





R.





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Prather, Wanda
Sent: Wednesday, November 17, 2004 2:20 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: dsmsched.log , reporting


It's the ACTLOG table.  One of the columns is SEVERITY (you can ask for
all E or W messages), or select on the specific message numbers that
have the information you want.

Andy's suggestion was better than mine, though - TOR will do all that
for you and even do the sums for you!

   



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mike Bantz
Sent: Wednesday, November 17, 2004 5:11 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: dsmsched.log , reporting


Any hints on what tables and columns to query off of? I'm comfortable
with a
select statement, but there isn't an obvious "ERRORS" table in the
database.

Thanks!
Mike Bantz

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Prather, Wanda
Sent: Wednesday, November 17, 2004 2:54 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: dsmsched.log , reporting

The client file failures and the summary information is all echoed back
to
the TSM server activity log - you can get it with a SELECT.