000033723 - How to extract Attachments from specific RSA Archer Modules 5.5 SP2 and newer

Document created by RSA Customer Support Employee on Aug 10, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000033723
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5 SP2 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). 
Resolution
  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. Execute 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.
 

Attachments

Outcomes