We've actually got that running - best daily overview that I can think of. Let's me know how I can start my day (one cup of coffee or three).
However, it's failing to allow reading of the attachments these days. I'll have to try and reinstall or something... Thanks! Mike -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Wednesday, November 17, 2004 3: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.