Just add additional criteria for the date
(('Create Date' >= "08/01/2007") AND ('Create Date' < "09/01/2007")) AND
...
If you are doing this in a Macro change "08/01/2007" to "$Start Date$"
and "09/01/2007" to "$End Date$" so it will prompt you
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO
Sent: Friday, September 14, 2007 1:09 PM
To: [email protected]
Subject: Re: Ticket Reporting - Outside Normal Business Hours (U)
UNCLASSIFIED
Do you know of a way to wildcard the date so that I can report on all of
"last month's" after hours tickets?
Sandra Hennigan
OSD Enterprise Remedy Administrator
Office # 703-602-2525 x251
Apparently, there is nothing that cannot happen today. Mark Twain
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Friday, September 14, 2007 11:42 AM
To: [email protected]
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
