000030593 - report of guids with report names

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 Number000030593
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.5 SP2
IssueCustomer needs a report listing with guids for datafeeds.
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));