We would like to do this in Access but are running into an issue with extra characters being recognized and fails to connect, currently running this in Excel. We are going to use the "< Closed" option due to it being the last in the list. And since this is going to be a process that is automated and updating every 2 minutes we kind of did not want to enter the actual date in the code. We were hoping to use a function similar to "$DATE$" to capture the current date, we currently have that function in a macro that spits the data to a csv like you mentioned. The only problem is that some of the macros will not have data in the early morning so that is why we are shooting for a SQL query. Remedy gives you an error when no data is found and since there is no way to not display errors like that it stops the rest of the Remedy macros from running behind it. I attached the macro that we are using.
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Friday, December 14, 2007 7:21 PM To: [email protected] Subject: Re: Remedy SQL query assistance... Please Help. ** Raul, are you running this query from within MS Excel? Crystal Reports? Also, If you're using an ARSystem ODBC driver the date conversion formula I gave you isn't necessary. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 12:35 PM To: [email protected] Subject: FW: Remedy SQL query assistance... Please Help. ** From: Zaldivar, Jack (ISD, IT) Sent: Friday, December 14, 2007 3:33 PM To: Martinez, Raul (ISD, IT) Subject: RE: Remedy SQL query assistance... Please Help. SELECT "HPD:HelpDesk"."Assigned To Group+", "HPD:HelpDesk"."Assigned To Individual+", "HPD:HelpDesk"."Assignee Login Name", "HPD:HelpDesk"."Case ID+", "HPD:HelpDesk".Source, "HPD:HelpDesk".Status, "HPD:HelpDesk"."Submitted By" FROM "HPD:HelpDesk" "HPD:HelpDesk" WHERE (dateadd(ss, (convert(int, "Create Date"))+(3600*-8), '01-01-1970 00:00:00') >= '12/13/2007' AND dateadd(ss, (convert(int, "Create Date"))+(3600*-8), '01-01-1970 00:00:00') < '12/14/2007') AND ("HPD:HelpDesk".Status<>'Resolved' And "HPD:HelpDesk".Status<>'Closed') ORDER BY "HPD:HelpDesk"."Case ID+" ________________________________ ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.jpg>>
AssignedToServDeskCombined.arq
Description: AssignedToServDeskCombined.arq
