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:[EMAIL PROTECTED] Behalf Of Prather, Wanda Sent: Wednesday, November 17, 2004 2:20 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Mike Bantz Sent: Wednesday, November 17, 2004 5:11 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Wednesday, November 17, 2004 2:54 PM To: [EMAIL PROTECTED] 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.
