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]<mailto:[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]<mailto:[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]<mailto:[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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
