Well that part I can't help with. It was just that looking at those numbers I figured that it seemed to go back to about then. Glad it gives you a starting point.
On Wed, Apr 2, 2008 at 8:52 AM, Gayford, Matthew C. <[EMAIL PROTECTED]> wrote: > ** > > 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 > > > > *M*atthew *C*. *G*ayford > *T*echnology *R*esearch & *D*evelopment > *I*nformation *T*echnology *S*ystems *D*ivision > *U*niversity of *N*orth *C*arolina *W*ilmington > (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 > > > > *M*atthew *C*. *G*ayford > *T*echnology *R*esearch & *D*evelopment > *I*nformation *T*echnology *S*ystems *D*ivision > *U*niversity of *N*orth *C*arolina *W*ilmington > (910) 962-7177 > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > __Platinum Sponsor: 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"