Yep.

My TSM server is 5.2.2 on Windows

Query:

select date(start_time) as date, activity, entity, successful from
summary where successful <> 'YES'

Partial results:  (because my tape robot was stuck)

2005-01-07     RESTORE                SSDAPPS2
NO
2005-01-08     RECLAMATION            BACKUPTAPE
NO
                                       (SSD094)

2005-01-14     MIGRATION              BACKUPDISK
NO
2005-01-14     MIGRATION              BACKUPDISK
NO
2005-01-14     MIGRATION              BACKUPDISK
NO
2005-01-14     MIGRATION              BACKUPDISK
NO
2005-01-14     MIGRATION              BACKUPDISK
NO
2005-01-15     MIGRATION              BACKUPDISK
NO
2005-01-15     MIGRATION              BACKUPDISK
NO
2005-01-15     MIGRATION              BACKUPDISK
NO




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
JR Trimark
Sent: Tuesday, March 01, 2005 11:33 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TSM Summary table question re:Successful column values


Can an entry exist in the summary table whose value of SUCCESSFUL is not
set to 'YES'?