Where are attachment files stored

2009-12-09 Thread Shane Buchholz
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

Re: Where are attachment files stored

2009-12-09 Thread LJ Longwing
12:37 PM To: arslist@ARSLIST.ORG Subject: Where are attachment files stored ** 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

Re: Where are attachment files stored

2009-12-09 Thread Jeremy Muchler
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

Re: Where are attachment files stored

2009-12-09 Thread Joe D'Souza
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

Re: Where are attachment files stored

2009-12-09 Thread Shane Buchholz
) [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

Re: Where are attachment files stored

2009-12-09 Thread Joe D'Souza
Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Shane Buchholz Sent: Wednesday, December 09, 2009 4:14 PM To: arslist@ARSLIST.ORG Subject: Re: Where are attachment files stored ** We had already discovered the B table that stores