Abulifia, Something like : "where cast((current_timestamp- end_time )hours as decimal) <= 24" should do the trick ...
However, if I remember properly, TDP's activity is not reported properly in summary table ... Double check before trusting your query ! Cheers. Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ronald Le Large Sent: Wednesday, 14 February, 2007 14:05 To: [email protected] Subject: SQL date convert Hi everybody, The last time when I posted a question I received a few very useful and quick replies. Thx for that. Hopefully this question is also easy for a few of you to answer. Case: A client want's to know how big the daily backup is for a Lotus client backedp up via TDP. I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a script but the output is useless (even with grep) because TDP reports a summary for every *.nfs its backing up and I am only interested in the total bytes transferred. (which is also reported with msg 4991 at the end of the log). The alternative (which has my preference ) is an sql query: select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]' and ACTIVITY='BACKUP' but I struggle with the date. The format TSM is using in its table is 2007-01-15 21:08:34.000000 I am only interested in the backupsize of last night so I use " START_TIME='2007-02-14%' but that is obviously not the correct syntax. Does anyone of you know how I must convert the date ? Or is there a possibility to use something like "today-1" like you use with a q actlog. Your advise would be highly appreciated. Thx in advance, Abulifia --------------------------------- New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes.
