It'll take a little bit of digging then ... The reporting is being done via Crystal. Should be fun ....
Ta! Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: 08 October 2007 10:38 To: [email protected] Subject: Re: ITSM 5 status history q Dave, This will be in the 'core' status history fields: 'Status.RESOLVED.TIME' etc. If you look in the database this will be held in the H tables. -- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 10/8/07, Barber, Dave <[EMAIL PROTECTED]> wrote: > ** > > > All, > > I'm sure I'm going to have a major d'oh! moment on this one. > > This is on the v5 apps - which field is the status history stored in? Thats > the time set to new/assigned/wip/pending/resolved/closed? > I haven't had to look into this field for years. Got a user wanting a time > it takes to resolve a ticket ... minus the time it was at pending. Its > probably not going to be accurate at all, but what the user wants, the user > gets, albeit with a warning of the potentially dubious accuracy of the data. > > Regards > > Dave ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Please consider the environment before printing this e-mail or its attachments. -------------------------------------------------------- This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [EMAIL PROTECTED] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd. unless otherwise expressly stated. NTT Europe Limited is a company registered in England and Wales with company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link: http://www.ntteurope.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
