000033723 - How to extract Attachments from specific RSA Archer Modules 6.x and newer

Document created by RSA Customer Support Employee on Aug 10, 2016Last modified by RSA Customer Support on Aug 26, 2020
Version 6Show Document
  • View in full screen mode

Article Content

Article Number000033723
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.x and newer
Platform: Windows
IssueHow to extract all Attachments for a specific Application or Questionnaire.
There may be a need to get Attachments files from particular RSA Archer Modules (Application and/or Questionnaire). 
  1. Create a "destination" directory (when you run the batch file, this is the target directory for the Attachments)
  2. Open the attached SQL query and modify the 3 parameter values in the SQL query:
    1. @SourceDirectory (File Repository)
    2. @DestinationDirectory
    3. @moduleName
  3. Run the SQL query against the RSA Archer Instance database.
  4. Copy the "copy_cmd" column.
  5. Create a text file using Notepad.
  6. Paste the SQL results from the "copy_cmd" column into the text file.
  7. "Save As" All Files and use a .bat extension.
  8. Run the batch file.
Note: The batch file will copy the attachments from the File Repository to the Destination directory for the RSA Archer Modules you specified in the query.