You would need to convert the timestamps for readability or you would see them as integers..
Joe From: irina solarcuka Sent: Wednesday, June 29, 2011 8:40 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Data for "Status History" by using Microsoft SQL Server Management Studio ** Hi, Remedy store the status-history in h tables. Please do the following: 1. Select schemaid from arschema where name='?????'; (???? means the form's name) 2. Select * from Hx (x= first select result) BR, Irina 2011/6/29 Mr. Tee <mrtee...@gmail.com> Hi ARS-LIST, Is it possible somehow to get data for “Status History” from Remedy SQL database by using Microsoft SQL Server Management Studio? Environment is ARS and ITSM 7.5.01 patch 001. Thanks in advance. Kind regards Mr. Tee _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"