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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Prather, Wanda
Sent: Wednesday, November 17, 2004 3: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.