This works great! Thanks so much, Julie Kanakanui Remedy Administrator/Developer Information Technology Services University of North Carolina at Greensboro [EMAIL PROTECTED]
"Grooms, Frederick W" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/14/2007 11:42 AM Please respond to [email protected] To [email protected] cc Subject Re: Ticket Reporting - Outside Normal Business Hours (U) ** Here is an example All tickets created between 5pm and 7am on any day: (((((( 'Create Date' - "1/1/70") % 86400) >= 17 * 3600) AND ((( 'Create Date' - "1/1/70" ) % 86400) <= 24 * 3600)) OR (((( 'Create Date' - "1/1/70") % 86400) >= 0 * 3600) AND ((( 'Create Date' - "1/1/70" ) % 86400) <= 7 * 3600)))) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA Sent: Friday, September 14, 2007 10:06 AM To: [email protected] Subject: Re: Ticket Reporting - Outside Normal Business Hours (U) ** "....great searches that will find records based on time criteria and the day piece of the date/time stamp is ignored..." I'd be very interested to hear more about such searches if anyone has any! We need to do this also. Thanks, Julie Kanakanui Remedy Administrator/Developer Information Technology Services University of North Carolina at Greensboro [EMAIL PROTECTED] "Shellman, David" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/13/2007 02:03 PM Please respond to [email protected] To [email protected] cc Subject Re: Ticket Reporting - Outside Normal Business Hours (U) In the past folks have presented some great searches that will find records based on time criteria and the day piece of the date/time stamp is ignored. Another process that can be used is to set a hidden field using Business Hours rules when the record is Resolved. The process adds 0 seconds to the current time. If it is outside of the business hours the hidden field will not be the same as the Resolved Date field. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Thursday, September 13, 2007 1:56 PM To: [email protected] Subject: Ticket Reporting - Outside Normal Business Hours (U) UNCLASSIFIED Our environment - Windows server 2003 ARS 6.3 patch 21 SQL 2000 Help Desk 5.5 SLA 5.5 I need to build a report that will include tickets submitted and/or resolved outside of normal business hours. The "Business Tag" field is of no assistance because it is written to on submit; tickets resolved after normal hours may have been submitted at any time in the past. The "Assigned to Group+" field is of no assistance because any of our techs may provide a service in or out side of normal business hours. Tickets will have been submitted and/or resolved after 1800 and before 0700 daily, Sunday thru Saturday. I have Crystal Reports. Any assistance is appreciated. Thanks. Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x251 Apparently, there is nothing that cannot happen today. Mark Twain __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
