000030593 - RSA Archer Report Listing with GUIDs for Data Feeds

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jul 16, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030593
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: All
IssueCustomer needs a report listing with GUIDs for data feeds.
ResolutionSELECT tblReportBaseTranslation.report_name, tblReportBase.guid, tblModule.module_id
FROM ((tblReportBase INNER JOIN tblReportBaseTranslation ON tblReportBase.report_base_id = tblReportBaseTranslation.report_base_id) INNER JOIN tblReportModuleCriteria ON tblReportBase.report_base_id = tblReportModuleCriteria.report_base_id) INNER JOIN tblModule ON tblReportModuleCriteria.module_id = tblModule.module_id
WHERE (((tblModule.module_id)=ENTER MODULE ID HERE));