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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
