Todd,
We did this with a home grown Helpdesk. I added an integer field and used a filter set fields action to put the HOUR($Create Date$) value into it. Then pull a report and look for the tickets with intHour >= 19 AND intHour <=21. HTH, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Wednesday, April 29, 2009 2:46 PM To: [email protected] Subject: Incident Count for a Time Period Each Day Is anyone running a report in Incident management 7.0 to count the number of incidents logged during a time period each day? For example, we want to know how many incidents were created between 7:00 PM and 9:00PM during a given week or month. I am not seeing any "time" field to use in the query on the incident form and wanted to check to see if I am just missing it or if there is another way to accomplish the report. My first thought is to add a Time field to the Incident form and populate past Incidents with the time but am wondering if that is the best way to go. TIA, Todd Arner Great Lakes _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

