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.