I was thinking the same thing, but why only on the report form and not from the incident query? I am bypassing the ARS server with the Report form correct?
So it is an ODBC direct to the Oracle side, but the data return its not the same On Tue, May 19, 2009 at 9:14 AM, Rick Cook <[email protected]> wrote: > Daylight savings time? > > Sent from my Verizon Wireless BlackBerry > > ------------------------------ > *From*: patrick zandi > *Date*: Tue, 19 May 2009 09:09:35 -0400 > *To*: <[email protected]> > *Subject*: reporting times - 1 hour question > > ** > I have found a scenario where if you query the form (incident) > ('1000000560' >= "5/19/2009 7:30:00 AM" AND '1000000560' <= "5/19/2009 > 9:00:00 AM") > > and it comes back with 4 tickets, however > if you use the report function of the incident console you get back 2 > the other 2 are not there, but if you change the query in the report > console > to 1 hour earlier > > ('1000000560' >= "5/19/2009 6:30:00 AM" AND '1000000560' <= "5/19/2009 > 9:00:00 AM") > now you get 4 again. > > We have looked at the oracle server, time is correct > We have looked at the ARS server, time is correct > We have looked at the oracle Config -- it is set to the servers time. > > now here is a question, how is it the report portion finds the data after a > minus of 1 hour and the data in the form is correct (time fields) > and yet the usertool finds it at the correct time just fine? This does > happen reguardless of the client, api source. > > anyone see this? > ENV:: > ars 7.1 -- patch 6 > cmdb 7.1 patch 5 > Solaris 10 - X64 > Oracle 10.2.0.5 --on solaris 10 > Everthing on UTC time (servers) > > > -- > Patrick Zandi > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
