usertool run on different machines different versions of the usertool (patch levels) and even run on one machine (usertool) that is ahead 1 hour (wrong time) Same results.
On Tue, May 19, 2009 at 9:13 AM, Lammey, Peter A. <[email protected]>wrote: > ** Did you run the report and the query from the same machine? > If they were different than its possible one of the machines that you > either ran the report or the query from was not adjusted for DST. > > Thanks > Peter Lammey > ESPN IT Client Architecture and Automation > 860-766-4761 > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *patrick zandi > *Sent:* Tuesday, May 19, 2009 9:10 AM > *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"_ > ------------------------------ > Please consider the environment before printing this e-mail. > _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"
