DB Attachments

This program got it’s root in the BMC Communities. There is a need at times to access Remedy attachments that exist in a DB when there is no longer a Remedy server sitting in front of the DB, this could be because it’s an archived server/version of Remedy, an archive database, or really any other reason you might have data in a database but no longer have a Remedy server standing in front of it. Accessing these attachments is an issue because before Remedy stuffs them in the db it compresses them, so unless you decompress the attachments when you pull them out of the db, you don’t have a viable/usable file, and BMC doesn’t use standard ‘zip’ compression. So, what this tool does is connects you directly to the DB via JDBC, analyzes your Remedy meta-data tables and presents you with options to pull the attachments out. There are two ways to do this, you can do it through the GUI with presents you with connection string builders, provides you with a list of forms/fields that attachments can be stored in as well as allowing you to execute queries against those tables presenting you with a browse-able list of attachment records with the option of saving one or all of them to the file system. The other method will allow you to specify commands at the command line allowing you to dump attachments out to directories directly without the use of a GUI at all.

Release History

1.3 – May 20th, 2019

  • Fixed a cursor problem that popped up when doing large quantities of attachments

1.2 – December 14th, 2018

  • Removed viewName column from the arschema query as it was causing issues with older versions of Remedy, and the value wasn’t being used

1.1 – March 31st, 2018

  • Added a build connection string button to the main window
  • Updated how the configuration is being saved to try to overcome a problem a user was having
  • Added filtering for the form box so that when it has focus, you can start typing to filter the list

1.0 – March 25th, 2018

  • Initial Release