My mistake....try this:
tsm: ADSM>select * from events where
days(current_timestamp)-days(scheduled_start)<1
SCHEDULED_START: 2001-01-05 00:30:00.000000
ACTUAL_START: 2001-01-05 00:30:24.000000
DOMAIN_NAME:
SCHEDULE_NAME: BACKUP_DEVCONFIG_3
NODE_NAME:
STATUS: Completed
RESULT: 0
REASON: Ok
Joseph Marchesani <[EMAIL PROTECTED]>
01/05/2001 08:39 AM
Please respond to "ADSM: Dist Stor Manager"
<[EMAIL PROTECTED]>@SMTP@Exchange
To: [EMAIL PROTECTED]@SMTP@Exchange
cc:
Subject: SQL query events
Adsm Group
In a previous Email from Jim Healy to the group, it was suggested
to use
the following WHERE statement: to get the prior day events.
Try adding
where days(current_timestamp)-days(date_time)<1
to your select statement...
The varibles DAYS, CURRENT_TIMESTAMP, & DATE_TIME are not part of
the
EVENTS table is there another table that has to be JOINED to the
events
table
to get the above variables.
I am using the Microsoft Excel ODBC query to get the event
information.
Thanks
Joe Marchesani
t---------------------- Forwarded by Joseph M
Marchesani/NYM/Equitable on
01/03/2001 03:13 PM ---------------------------
James J Healy
12/29/2000 11:50 AM
To: Joseph M Marchesani/NYM/Equitable@AXA-Equitable
cc:
Subject: Re: SQL query for events
---------------------- Forwarded by James J Healy/NYM/Equitable on
12/29/2000 11:49 AM ---------------------------
"Williams, Tim" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
12/29/2000
11:38:32 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: SQL query for events
try adding
where days(current_timestamp)-days(date_time)<1
to your select statement...
"<James> <healy>" <[EMAIL PROTECTED]>
12/29/2000 09:34 AM
Please respond to "ADSM: Dist Stor Manager"
<[EMAIL PROTECTED]>@SMTP@Exchange
To: [EMAIL PROTECTED]@SMTP@Exchange
cc:
Subject: SQL query for events
Can anyone help with the sql query I could use to see events
that
occurred
form yesterday to today?
