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:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: 03 March 2005 20:15 To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of JR Trimark Sent: Tuesday, March 01, 2005 11:33 AM To: ADSM-L@VM.MARIST.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'?
