Thanks Brian. What you've said appears to make sense, as some of the records list a total time spent of 330,000+ hours, which comes out to over 37 years. That would put us in 2007 which would make sense for some of these tickets. The strange part is that only about 200 or so of the tickets have these strange dates and the rest are fine.
Matt Matthew C. Gayford Technology Research & Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk Sent: Wednesday, April 02, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: Reporting Time to Resolve ** Matt, I am just taking a random whack at this, but could it be that those records don't have the date information your looking for and as such, are displaying the time since January 1st, 1970? Not sure if that has anything to do with it, but something you might look into. Brian On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. <[EMAIL PROTECTED]> wrote: ** List, I've been tasked with writing some reports to get the duration of time in which tickets were open. We don't have SLM installed, so I decided that I would report off of the Incident Assignment Log. Here's the query: SELECT Incident_Number, SUM(BusinessHoursDurationSeconds) AS TimeOpen FROM HPD_Help_Desk_Assignment_Log GROUP BY Incident_Number ORDER BY TimeOpen DESC So everything was going well until I noticed some of the numbers appear out of whack. For instance, there are a number of tickets where the "business hours duration" field is 334939:53:44 and the "business hours duration (sec)" field is 1205783624. Does anyone out there have any good ideas on what could be going wrong here? TIA. -Matt Matthew C. Gayford Technology Research & Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
