Meta-Update - running entirely through the API - has a rich facility for retrieving attachments to the file system. Attachments can be named anything at all in an automated way and can also be processed if needed. See www.softwaretoolhouse.com for more info.
Cheers Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: August-17-12 02:53 To: [email protected] Subject: Re: Retrieving Attachments from ARS DBs ? Hi, I wonder why BMC chose a proprietary compression mechanism. I don't see the benefit, really. Except possibly if BMC programmers has developed a more efficient mechanism than exists elsewhere. Why not publish the code for it? My point of view is to use the API anyway. To quote a recent post from Doug Mueller: "As someone has already mentioned, other than for your amusement and amazement, it is bad practice to access the T tables directly..." I would think that this would include the B-tables as well ;-) Best Regards - Misi, RRR AB, http://rrr.se > Attachments are stored in a proprietary compression format so you > cannot retrieve them without using the API to decompress them. > > Since you are on SQL you could possibly use the ARS ODBC to pull the > attachment (but I have not tried that) > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Rick Sharp > Sent: Thursday, August 16, 2012 5:06 PM > To: [email protected] > Subject: Retrieving Attachments from ARS DBs ? > > ** > Hi All - > > Our SQL DBA is looking for best practice advice on how to retrieve > attachments in INC and CRQ records/work info entries. On page 37 of > the DB ref guide, it tells what table(s) to find the attachment > images, which we have found. Goal: To retrieve documentation files > that are part of work info entries, and are in the ARS attachment data > tables. Environment: ARS 7.02 and SQL 2K8 Has anyone done this > in the past ? Do you have an example of the SQL statement ? The > field element in the B/C tables indicates the attachments are "imaged" > types. > > Thanks in advance very much ! > > Rick > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
