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: [email protected] 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 <[email protected]> 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"
