000027420 - How to extract attachment information within RSA Archer with associated contentID and the actual file information.

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000027420
Applies To

-- Query takes actual file / attachment name and RSA Archer FileID, and merges them to make an RSA Archer Filename. Query will also show related contentID and the actual filename.

Select
a.content_id as ContentID,
Reverse(STUFF(REVERSE(b.file_name),CHARINDEX('.',REVERSE(b.file_name))+1,LEN(REVERSE(b.file_name)),REVERSE(b.file_id))) as Archer_FileName,
b.file_name as Actual_FileName
from tblxivcontentrepositorylinks(NOLOCK) a
join tblRepositoryFile(NOLOCK) b on a.file_id=b.file_id
join tblIVFieldDef(NOLOCK) c on c.field_id=a.field_id


Results will be in the format below:

ContentID     Archer_FileName     Actual_FileName
=========    
==============      ==============
140543        14.csv              devices.csv
140544        15.config           original.web.config

5.x
IssueSQL Query: How to extract attachment information from RSA Archer with associated contentID and the actual file information.
Legacy Article IDa60440

Attachments

    Outcomes