ADSM-L

Re: [ADSM-L] TSM Oper. Report for Missed Files

2007-05-22 07:20:39
Subject: Re: [ADSM-L] TSM Oper. Report for Missed Files
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 22 May 2007 07:19:00 -0400
On May 22, 2007, at 3:11 AM, Stefan Holzwarth wrote:

"and nodename in (select nodename from nodes where
domain_name='MAC') "

                           ^^^^^^^
That should instead be:    NODE_NAME

Note well the unfortunate field name variations across tables.

2) since the original query above works with date strings I have to
substitute that part with something like that being using in q actlog
begind=-24:00 ...

I think you mean   begint=-24:00

The Select prototype would be:
 SELECT * From ACTLOG where  -
  CAST((CURRENT_TIMESTAMP-DATE_TIME) HOURS AS INTEGER) < 24

 Richard Sims

<Prev in Thread] Current Thread [Next in Thread>