Thanks. ARS is the epoch worker.
On Tue, May 19, 2009 at 12:31 PM, Lyle Taylor <[email protected]> wrote: > ** > > This probably won’t help answer your initial question, but to answer the > question you asked below, the report form does not bypass the AR server. > The Crystal-based reports that use the ODBC driver use the Remedy ODBC > driver which just emulates a direct database connection. It uses the Remedy > API to query the Remedy database just like the user tool does; it doesn’t go > directly against the database. > > > > Lyle > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *patrick zandi > *Sent:* Tuesday, May 19, 2009 7:21 AM > *To:* [email protected] > *Subject:* Re: reporting times - 1 hour question > > > > ** > > 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 > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > > > > NOTICE: This email message is for the sole use of the intended recipient(s) > and may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy all > copies of the original message. > _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"
