000029422 - Query to retrieve the history log along with the tracking ID and user name

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 Number000029422
Applies ToRSA Product Set : Archer

RSA Version/Condition : 5.x
Note: This query will work only on versions prior to 5.5.2.

Platform : Windows
IssueQuery to retrieve the history log along with the tracking ID and user name
Resolution
select CH.content_id, FD.history_id, FD.field_id, Ft.field_name, FD.original_value, 
FD.new_value,FD.create_date,U.user_username
From tblIVFieldHistory FD join tblUser U on U.user_id = FD.create_login join tblIVFieldDef
FDD ON FDD.field_id = FD.field_id join tblLevel L
on L.level_id = FDD.level_id join tblModule M ON M.module_id = L.module_id
join tblFieldTranslation FT on
FDD.field_id = FT.field_id join tblIVContentHistory CH on CH.history_id = FD.history_id
where M.module_id = '<Insert Module ID here>'

Attachments

    Outcomes