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.
