on Jun 14, 2016Article Content
| Article Number | 000012052 |
| Applies To | RSA Archer 5.X |
| Issue | Query to retrieve information about the file repository file and module IDs, content IDs & field ID's |
| Resolution | QUERY: =================== SELECT c. content_id, a .field_id, a.field_name , e. file_name,e .file_id, f.module_name, f.module_idFROM tblIVFieldDef a INNER JOIN tblLevel b on a .level_id = b.level_id INNER JOIN tblIVContent c on b .module_id = c.module_id INNER JOIN tblXIVContentRepositoryLinks d on d .content_id = c.content_id and d. field_id = a .field_id INNER JOIN tblRepositoryFile e on e .file_id = d. file_id INNER JOIN tblModule f on c .module_id = f.module_id |
| Legacy Article ID | a67776 |