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:[email protected]]on Behalf Of Jeremy Muchler Sent: Wednesday, December 09, 2009 3:35 PM To: [email protected] 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 <[email protected]> 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

