Article Number | 000033723 |
Applies To | RSA Product Set: Archer RSA Version/Condition: 6.x and newer Platform: Windows |
Issue | How 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 | - Create a "destination" directory (when you run the batch file, this is the target directory for the Attachments)
- Open the attached SQL query and modify the 3 parameter values in the SQL query:
- @SourceDirectory (File Repository)
- @DestinationDirectory
- @moduleName
- Run the SQL query against the RSA Archer Instance database.
- Copy the "copy_cmd" column.
- Create a text file using Notepad.
- Paste the SQL results from the "copy_cmd" column into the text file.
- "Save As" All Files and use a .bat extension.
- 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.
|