Re: [ADSM-L] query node vs select * from nodes
2010-03-26 13:55:43
Fraustratingly, you'll need to use an absolute date (rather than relative date
as below) when selecting from the events table.
/David Mc
------Original Message------
From: Guenther Bergmann
Sender: ADSM: Dist Stor Manager
To: ADSM-L AT VM.MARIST DOT EDU
ReplyTo: ADSM: Dist Stor Manager
Subject: [ADSM-L] query node vs select * from nodes
Sent: 26 Mar 2010 17:22
Hi TSMers,
If i do:
q event * * begind=today-1
i get a lot of output for events that happened yesterday.
If i issue:
select * from events where days(current_timestamp)-days(scheduled_start)>1
i get no results. Can someone explain the difference? What does q event do
other than selecting information from the events table?
Thanks in advance
regards Günther
--
Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany
Guenther_Bergmann at gbergmann dot de
Sent from my BlackBerry® wireless device
|
|
|