Personally I prefer to use the SH_xxxxxxxxxx views that are created (Where xxxxxxxxxxxxx is ~ the form name). They use actual field names instead of the database IDs for the columns.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of irina solarcuka Sent: Wednesday, June 29, 2011 7:41 AM 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 -----Original Message----- 2011/6/29 Mr. Tee 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"
