We had already discovered the B table that stores the information, but as you mentioned we could not do anything with it. I will see if we can get them exported and access them that way. Thank you all for your responses.
Shane From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, December 09, 2009 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Where are attachment files stored ** Shane, They are stored in the corresponding B tables in the database, but like LJ mentioned, there is no point really of knowing that as access to attachment can be done only using the API layer.. They are stored in the B tables using a proprietary compression format. So retrieving them in a compressed format without having them uncompressed is of no value. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Jeremy Muchler Sent: Wednesday, December 09, 2009 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Where are attachment files stored ** The attachments are stored on a separate table in the database. Full details (and diagrams) are available in the Databse Reference Guide on page 27 (for diagrams) and page 38 for the description specific to how attachments are stored. If you do not have the Database Ref doc, please contact me off list and I can send it to you. Thanks, Jeremy On Wed, Dec 9, 2009 at 2:36 PM, Shane Buchholz <sha...@samhealth.org<mailto:sha...@samhealth.org>> wrote: ** We are working to build a front end interface to access data from an old Remedy database. I am trying to determine how to grab attachments from the system. If anyone has information on this I would appreciate it. ARS 6.3 ITSM 5.6 SQL 2000 Windows Server 2003 Thanks, Shane Buchholz Systems Analyst 2 - Remedy Information Services - Operations ________________________________ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"