Can any one suggest how I can alter this query to show the time and also
for events between specific dates/times. 

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

Cheers.
Iain


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Prather, Wanda
Sent: 03 March 2005 20:15
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TSM Summary table question re:Successful column
values

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'?