Hi Mr Tee, The Status history can be found in the 'H' table for the form that you are interested in.
SELECT schemaId FROM arschema WHERE name = '<form name>' The status history is in the table H<schemaId> Hope this helps, Ian (also known as "Mr T.") ________________________________ Ian Trimnell, Systems Programmer, Client Systems Distributed Systems, Information Technology The Open University, Milton Keynes, UK Phone: 01908 653741 web: http://www.open.ac.uk/ On 29/06/2011 13:25, "Mr. Tee" <[email protected]<mailto:[email protected]>> wrote: 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" -- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
