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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"